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.