Select first row for each group in PostgreSQL
Given a table
We want to find the rows containing the maximum number of points per team.
The expected output we want is:
From the SQL Editor, you can run a query like:
select distinct on (team) id, team, points from seasons order BY id, points desc, team;
The important bits here are:
desckeyword to order the
pointsfrom highest to lowest.
distinctkeyword that tells Postgres to only return a single row per team.
This query can also be executed via
psql or any other query editor if you prefer to connect directly to the database.