/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

2 votes142 views1 answer
Can you use a where clause for a child query
SQL
0 vote181 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote144 views1 answer
Sql server 2012 query history
SQL
6 votes192 views2 answers
What is non relational database
SQL
11 votes197 views2 answers
Having keyword sql
SQL
0 vote153 views1 answer
Sql create text column limited values
SQL
1 vote149 views1 answer
How to delete record sql delphi
SQL
1 vote155 views2 answers
Postgresql get difference in hours between two dates
SQL
1 vote144 views1 answer
Oracle truncate partition
SQL
0 vote212 views1 answer
Microsoft sql server python connection
SQL