/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 vote211 views1 answer
T-sql check if data exists
SQL
0 vote205 views1 answer
2020 new year
SQL
0 vote212 views7 answers
10 random questions use python and SQL
SQL
0 vote250 views1 answer
Plsql check how much space all databases are consuming
SQL
2 votes199 views1 answer
How to delete view in sql
SQL
4 votes234 views1 answer
Oracle user tables
SQL
0 vote317 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote225 views1 answer
Sql log file inof
SQL
0 vote226 views1 answer
Postgre query date
SQL
8 votes235 views1 answer
Oracle tablespace datafile max size
SQL