/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 votes168 views3 answers
Mysql current date
SQL
0 vote177 views1 answer
Search from comma separated values in sql server
SQL
1 vote191 views1 answer
Oracle lowercase
SQL
0 vote306 views1 answer
Android sqlite add column if not exists
SQL
8 votes236 views2 answers
Change name of colum in sql table
SQL
0 vote177 views1 answer
Closure in sql
SQL
0 vote185 views1 answer
Mysql drop vs delete
SQL
13 votes180 views3 answers
Change data type postgresql
SQL
0 vote217 views3 answers
Constraint sql
SQL
4 votes278 views6 answers
Laravel jwt
SQL