/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

0 vote206 views1 answer
Mariadb set vertical output format
SQL
0 vote187 views1 answer
Sql server manager close connection
SQL
49 votes197 views6 answers
Alter table add column
SQL
0 vote192 views1 answer
List MySQL Table and Index Size
SQL
0 vote215 views1 answer
Joomla execute raw sql
SQL
0 vote200 views1 answer
Sql server synonym
SQL
0 vote183 views1 answer
Eliminar ultimo carcacter mysql
SQL
1 vote195 views1 answer
Drop function
SQL
5 votes213 views1 answer
Sql integer to serial
SQL
2 votes195 views2 answers
Sql strip non alphanumeric characters
SQL