1. 학습
    2. /
  2. 강의
    3. /
  3. PostgreSQL Summary Stats and Window Functions
Connected

연습 문제

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.

지침

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