Sql select whole row max column

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

14 votes373 views2 answers
Oracle limit rows
SQL
0 vote412 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote334 views1 answer
Show all mongodb
SQL
0 vote373 views1 answer
How to delete duplicate rows in oracle
SQL
52 votes609 views6 answers
Rename column sql
SQL
17 votes405 views3 answers
Postgresql list users
SQL
4 votes359 views3 answers
Copy table postgres
SQL
36 votes375 views3 answers
Add column in mysq
SQL
1 vote344 views1 answer
Postgresql last element of array
SQL
0 vote347 views1 answer
How to get data between a last week in mysql
SQL