/SQL/Get first match in each group mysql query

Get first match in each group mysql query

WITH added_row_number AS (
  SELECT
    *,
    ROW_NUMBER() OVER(PARTITION BY year ORDER BY result DESC) AS row_number
  FROM exam_results
)
SELECT
  *
FROM added_row_number
WHERE row_number = 1;

Source: learnsql.com

Similar codes

3 votes283 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote298 views1 answer
Mysql limit order by
SQL
16 votes329 views1 answer
Mysql mediumint max value
SQL
0 vote272 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote258 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote256 views1 answer
Import all databases mysql
SQL
2 votes296 views1 answer
Sql server: select column values as comma separated string
SQL
6 votes270 views5 answers
Get current date sql
SQL
13 votes277 views5 answers
Sql default
SQL
0 vote298 views1 answer
Sql delete caracter list
SQL