/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

10 votes313 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote301 views1 answer
Psotgres multiple values
SQL
1 vote295 views1 answer
Postgres cast as currency format
SQL
0 vote275 views3 answers
Get count of null in column sql
SQL
0 vote299 views1 answer
Mysql add text to existing field
SQL
0 vote359 views1 answer
Trigger
SQL
1 vote272 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
4 votes300 views3 answers
Sql drop primary key
SQL
0 vote273 views2 answers
How to see table associated with a schema in sql
SQL
0 vote268 views2 answers
Sqlite
SQL