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

5 votes157 views2 answers
Sql conn
SQL
2 votes160 views1 answer
Mysql query unique column
SQL
0 vote172 views1 answer
Ms sql filter all sympbol
SQL
1 vote169 views1 answer
Oracle stop job
SQL
1 vote220 views1 answer
Autocommit mysql
SQL
5 votes179 views1 answer
Pl sql asynchronous procedure calls
SQL
10 votes191 views2 answers
Sql pagination offset
SQL
1 vote159 views1 answer
How to use a trigger to validate input data
SQL
0 vote164 views1 answer
Add multiple field in table sql
SQL
0 vote210 views1 answer
Mysql select row with min date
SQL