/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 vote111 views1 answer
Call procedure in wordpress
SQL
0 vote125 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
2 votes150 views1 answer
Laravel sql String
SQL
4 votes121 views1 answer
Sql delete multiple conditions
SQL
2 votes138 views2 answers
Change mysql password from command line
SQL
0 vote143 views1 answer
Php select data from mysql database without column name
SQL
0 vote143 views1 answer
How to check event scheduler status mysql
SQL
4 votes141 views1 answer
List tables sqlite
SQL
0 vote147 views1 answer
Alter database name script
SQL
0 vote112 views1 answer
Insert thai language sql server
SQL