/SQL/Mysql select row with max value group by

Mysql select row with max value group by

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

27 votes372 views5 answers
Add column in table
SQL
0 vote366 views1 answer
Hotw to alter lengh character vayng postgres
SQL
15 votes355 views4 answers
Pl sql
SQL
0 vote380 views1 answer
Faire une recherche par liste de mot clé sql
SQL
4 votes312 views1 answer
Install postgres 12 on ubuntu
SQL
1 vote396 views1 answer
Sqlite update from another table
SQL
5 votes361 views2 answers
Get columns number sql
SQL
0 vote380 views1 answer
Sql query tags
SQL
0 vote424 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote373 views1 answer
Print mysql
SQL