/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 vote312 views1 answer
Mysql command line ubuntu
SQL
0 vote287 views1 answer
Create duplicate table in postgresql
SQL
0 vote335 views1 answer
Sql if clause within where clause
SQL
0 vote546 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
1 vote345 views1 answer
Oracle get current schema
SQL
0 vote301 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote299 views1 answer
Procedures and functions in pl/sql
SQL
12 votes295 views4 answers
SQL Where
SQL
2 votes306 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote342 views1 answer
Excel export from sql using python
SQL