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 vote171 views1 answer
Acutal month year
SQL
0 vote170 views1 answer
Show specific events on mysql
SQL
0 vote193 views1 answer
Oracle lower in where clause
SQL
0 vote177 views1 answer
Oracle create table auto generated primary key
SQL
1 vote160 views1 answer
Oracle lock user
SQL
0 vote183 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote205 views1 answer
Combine 2 columns search query mysql
SQL
0 vote178 views1 answer
Select password from user mysql
SQL
10 votes130 views2 answers
Django mysql
SQL
0 vote177 views1 answer
Sql case when exists in another table
SQL