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 vote282 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
22 votes272 views4 answers
Tsql rename table
SQL
0 vote274 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote258 views1 answer
Strat with in sql
SQL
0 vote292 views1 answer
Tsql table column constraint must be uppercase
SQL
10 votes272 views4 answers
Mysql one week ago
SQL
0 vote263 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote311 views1 answer
Pgadmin check database
SQL
1 vote291 views1 answer
Psql filed name alter
SQL
3 votes315 views5 answers
No module named 'MySQLdb'
SQL