/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 vote147 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
3 votes149 views1 answer
Laravel paginate raw sql
SQL
0 vote159 views1 answer
Datagrip exec
SQL
0 vote156 views1 answer
Drop all procedures sql server
SQL
0 vote145 views1 answer
Postgresql parse json array
SQL
2 votes164 views4 answers
2nd highest salary in mysql
SQL
0 vote141 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote160 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote164 views1 answer
Sql server for loop
SQL
5 votes172 views1 answer
Oracle asynchronous query
SQL