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

1 vote186 views1 answer
Postgres format date in select
SQL
6 votes175 views1 answer
Postgresql add enum value
SQL
0 vote175 views1 answer
Postpresql relation not found
SQL
0 vote167 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote186 views1 answer
Select year from dual oracle
SQL
5 votes276 views1 answer
Oracle asynchronous procedure
SQL
2 votes168 views1 answer
SELECT INTO
SQL
0 vote210 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote131 views1 answer
Calculate discount from original price sql
SQL
1 vote189 views1 answer
Postgres see sequence current state
SQL