/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 vote98 views1 answer
Create temporal table in sql
SQL
5 votes101 views1 answer
Sql add column after another
SQL
2 votes110 views1 answer
Node and mysql like
SQL
0 vote123 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote105 views1 answer
Logtash mysql cofiguration file
SQL
0 vote94 views1 answer
How to search query in python3 sqlite3
SQL
0 vote100 views1 answer
Difference between 2 query results sql server
SQL
16 votes101 views2 answers
Gremove folder from git
SQL
0 vote123 views1 answer
Query to insert image
SQL
0 vote108 views1 answer
Mysql filter based on datediff
SQL