/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 vote240 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote258 views1 answer
Example database query
SQL
1 vote247 views1 answer
Oracle undo usage per session
SQL
0 vote218 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
2 votes240 views1 answer
How to insert string variable into sqlite database
SQL
0 vote232 views1 answer
Sql database connectivity
SQL
11 votes231 views2 answers
Docker create postgres db
SQL
6 votes234 views1 answer
Postgresql add enum value
SQL
0 vote230 views1 answer
Get who is hired in january in sql
SQL
0 vote251 views1 answer
How to find table lock and row lock in mysql
SQL