/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 vote319 views1 answer
10000000000000000000 am to meters
SQL
0 vote418 views1 answer
Drop table BigQuery table columns
SQL
1 vote326 views1 answer
SQLite order random
SQL
0 vote325 views3 answers
Insert or ignore postgres
SQL
5 votes373 views2 answers
How to ascending order in sql
SQL
7 votes319 views4 answers
Database dump mysql command
SQL
0 vote318 views1 answer
How to put is null in where in clause
SQL
4 votes328 views1 answer
T-sql get duplicate rows
SQL
1 vote330 views2 answers
How to add amount between date in sql
SQL
0 vote323 views1 answer
How to convert DateTime to VarChar SQL
SQL