/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

16 votes132 views1 answer
Mssql int max value
SQL
10 votes131 views1 answer
Oracle object dependencies
SQL
0 vote124 views1 answer
Mysql command line ubuntu
SQL
0 vote92 views1 answer
Big query add table rows to another table
SQL
1 vote118 views1 answer
Oracle rolling back
SQL
0 vote118 views1 answer
Full syntax inner join
SQL
2 votes138 views2 answers
Mysql limit
SQL
1 vote122 views2 answers
Mysql show views
SQL
0 vote131 views1 answer
Sintaxis SELECT sql
SQL
4 votes120 views1 answer
Oracle table statistics last analyzed
SQL