Sql row having max

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 vote264 views2 answers
Php convert dbf to mysql
SQL
13 votes250 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote267 views1 answer
Import sql dump into postgresql database
SQL
-1 vote270 views1 answer
Su: Authentication failure mysql
SQL
2 votes275 views4 answers
Duplicate record mysql
SQL
0 vote290 views1 answer
Left join vs inner join performance
SQL
1 vote263 views1 answer
Add constraint sql
SQL
0 vote269 views1 answer
Sql select with apostrohpe
SQL
0 vote290 views1 answer
Oracle list partitions
SQL
0 vote284 views1 answer
Mysql extract day from date leading zero
SQL