/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 vote91 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote157 views1 answer
Python sqlalchemy connection show server
SQL
0 vote141 views1 answer
Plpgsql if statement
SQL
0 vote149 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote148 views1 answer
Set engine to innodb
SQL
12 votes135 views4 answers
Import mysql database command line linux
SQL
1 vote152 views2 answers
Drop table with constraints
SQL
35 votes151 views5 answers
Sql alter column
SQL
0 vote220 views1 answer
How to find the most occuring in SQL
SQL
0 vote161 views1 answer
MySQL get all previous date record
SQL