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 vote189 views1 answer
Mysql page segment
SQL
11 votes175 views1 answer
Mysql order by two columns priority
SQL
2 votes191 views1 answer
Q operator in oracle
SQL
1 vote181 views1 answer
Crontab every month
SQL
0 vote228 views1 answer
Count column of tables psql
SQL
2 votes193 views1 answer
Oracle index size
SQL
1 vote196 views1 answer
Sql random sampling per group
SQL
3 votes180 views1 answer
Créer une table sql
SQL
0 vote211 views1 answer
How to change the field size of an existing column
SQL
1 vote193 views1 answer
Oracle enable job
SQL