1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. PostgreSQL Summary Stats and Window Functions
Connected

Bài tập

First athlete by name

It's often useful to get the first or last value in a dataset to compare all other values to it. With absolute fetching functions like FIRST_VALUE, you can fetch a value at an absolute position in the table, like its beginning or end.

Hướng dẫn

100 XP
  • Return all athletes and the first athlete ordered by alphabetical order.