/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

2 votes197 views1 answer
Sql as
SQL
0 vote205 views1 answer
With_for_update sqlalchemy
SQL
26 votes450 views6 answers
Modify column name in sql
SQL
2 votes189 views1 answer
Update with join sql server
SQL
0 vote194 views1 answer
Set column in all row mysql
SQL
2 votes195 views1 answer
Oracle kill job by sid
SQL
3 votes210 views1 answer
Sql multi column index performance
SQL
0 vote334 views2 answers
Execute stored procedure without db set
SQL
1 vote211 views2 answers
Drop table if exists test
SQL
0 vote259 views1 answer
Mql5 datetime get hour
SQL