/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 votes230 views1 answer
Anonymous block plsql
SQL
2 votes215 views2 answers
Select multiple tables mysql
SQL
0 vote234 views1 answer
How get data from database if id not found then search another column
SQL
0 vote244 views2 answers
What is the default password for sql server sa
SQL
4 votes230 views1 answer
Sql delete where in select
SQL
0 vote239 views1 answer
Sql server count all tables rows
SQL
40 votes232 views6 answers
Update table mysql
SQL
5 votes253 views2 answers
Sql constraint check value in list
SQL
1 vote239 views1 answer
Raw query must include primary key
SQL
0 vote225 views1 answer
C# datetime to sql server datetime
SQL