Select first row for each group in Postgres

Given a table seasons:

We want to find the rows containing the maximum number of points per team.

The expected output we want is:

Run the following SQL using the SQL Editor in the Supabase Dashboard or with psql over a direct connection. To connect with psql, see Direct connection.

1
select distinct
2
  on (team) id,
3
  team,
4
  points
5
from
6
  seasons
7
order by
8
  team,
9
  points desc;

The important bits here are:

• The desc keyword to order the points from highest to lowest.
• The distinct keyword that tells Postgres to only return a single row per team.