/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 vote202 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote206 views1 answer
Postgresql import a database of gzip
SQL
0 vote194 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote213 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
2 votes231 views1 answer
How to delete all duplicate items in mysql
SQL
25 votes205 views4 answers
Sqlserver add column
SQL
0 vote195 views2 answers
2nd max salary query in sql
SQL
2 votes213 views1 answer
Mysql select true or false
SQL
0 vote191 views1 answer
Get all employees if name ends with in sql
SQL
0 vote185 views1 answer
Oracle current timestamp
SQL