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

0 vote302 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
7 votes366 views2 answers
Drop index oracle
SQL
0 vote312 views1 answer
Mssql dockere
SQL
3 votes288 views1 answer
How to uninstall microsoft sql server
SQL
2 votes295 views2 answers
Postgres select duplicate columns
SQL
0 vote314 views1 answer
Tinydb add table
SQL
-1 vote287 views1 answer
Add column alter table default value
SQL
3 votes304 views1 answer
Sql online test questions and answers
SQL
3 votes312 views2 answers
Sql not contains
SQL
0 vote287 views1 answer
Django how to get query result count
SQL