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

0 vote194 views1 answer
Mysql join column order By and group By
SQL
1 vote162 views1 answer
Delete row mssql
SQL
6 votes194 views1 answer
How to get the size of the database in postgresql
SQL
-2 votes180 views1 answer
No module named '_sqlite3
SQL
0 vote178 views1 answer
MySQL update with subquery
SQL
-1 vote189 views1 answer
Create view in mysql workbench
SQL
0 vote252 views2 answers
Mysql insert rows to another database
SQL
1 vote181 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote174 views1 answer
Psql list view rules
SQL
1 vote160 views1 answer
Apex run 404
SQL