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 vote227 views1 answer
Sqlcmd no headers
SQL
6 votes202 views1 answer
Update left join mysql
SQL
4 votes215 views1 answer
Sql data types
SQL
0 vote208 views1 answer
Import sql in postgresql
SQL
0 vote203 views1 answer
Sql query to force the database to be drop
SQL
0 vote198 views1 answer
Oracle index hint
SQL
1 vote229 views1 answer
Oracle plan hash value
SQL
1 vote187 views1 answer
Sql delete row with auto increment
SQL
10 votes247 views2 answers
What is database
SQL
2 votes249 views2 answers
How to add not null constraint in sql
SQL