/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

0 vote199 views4 answers
How to get max salary in each department in sql
SQL
4 votes190 views1 answer
Psql get sequences
SQL
0 vote208 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote191 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote189 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote188 views1 answer
Drop a field in psql django
SQL
0 vote449 views1 answer
Create pl/sql stored procedure
SQL
1 vote194 views1 answer
Lpad function in sql oracle
SQL
0 vote192 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote207 views1 answer
Tinydb add table
SQL