/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 vote292 views1 answer
Foreign key in oracle sql developer
SQL
4 votes108 views1 answer
Mysql copy table with new name
SQL
4 votes101 views2 answers
Postgresql reset sequence
SQL
0 vote106 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote143 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote105 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote104 views1 answer
Sql delete row with auto increment
SQL
0 vote123 views1 answer
Sql filter rows with condition
SQL
0 vote108 views1 answer
Python sql last insertend
SQL
3 votes136 views1 answer
Apex set debug level
SQL