/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 vote204 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
2 votes232 views2 answers
Spring where to put the data sql
SQL
0 vote220 views3 answers
Remove folders from remote git
SQL
0 vote213 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote207 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote229 views1 answer
Psql connect
SQL
1 vote182 views1 answer
Insert into sql
SQL
3 votes237 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote207 views1 answer
Concatenate columns in table
SQL
0 vote213 views2 answers
Mysql select date from datetime
SQL