/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

1 vote226 views1 answer
Psql human readable
SQL
0 vote229 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote206 views6 answers
In sql
SQL
0 vote218 views1 answer
Tsql table column constraint must be uppercase
SQL
10 votes214 views2 answers
Reset mysql root password mac
SQL
0 vote220 views1 answer
Sql select random procentage from rows
SQL
-2 votes225 views1 answer
Trunc in sql
SQL
0 vote222 views1 answer
Search starting with mysql
SQL
0 vote221 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote200 views1 answer
Oracle start job
SQL