/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 vote172 views1 answer
Mysql user set plugin
SQL
0 vote171 views1 answer
How to print out column name differently in mysql
SQL
1 vote176 views1 answer
Select dba users oracle
SQL
2 votes174 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote182 views1 answer
Firebase sql
SQL
0 vote159 views1 answer
Sql compound operators
SQL
0 vote198 views1 answer
Mysql get first 2 characters of string
SQL
8 votes171 views3 answers
Oracle auto_increment
SQL
0 vote171 views3 answers
Above average salary in sql
SQL
1 vote168 views1 answer
Mysql connect command
SQL