/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

18 votes161 views3 answers
Mysql add column default value
SQL
1 vote137 views1 answer
Sql server cast date dd/mm/yyyy
SQL
3 votes129 views2 answers
Oracle synonym
SQL
1 vote131 views2 answers
Drop function in sql
SQL
1 vote137 views1 answer
How to update date add hours in postgresql
SQL
14 votes142 views1 answer
Sql value of string
SQL
0 vote135 views2 answers
Check mysql timezone
SQL
0 vote134 views1 answer
Postpresql relation not found
SQL
0 vote132 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote135 views1 answer
Oracle avg
SQL