/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

1 vote114 views2 answers
How to drop a unique constraint in sql
SQL
2 votes105 views1 answer
Sql alchemy or
SQL
0 vote115 views1 answer
Rollback to name in sql
SQL
0 vote124 views2 answers
Impala rename column name
SQL
0 vote105 views1 answer
Select from column mysql
SQL
0 vote108 views1 answer
Double in sql server example
SQL
10 votes106 views4 answers
Drop primary key
SQL
0 vote111 views1 answer
Import sql in postgresql
SQL
0 vote123 views1 answer
Varchar format not case sensitive sql
SQL
5 votes121 views1 answer
Purge undo tablespace usage
SQL