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

2 votes198 views1 answer
Power query concatenate
SQL
0 vote301 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote229 views1 answer
Delete mysql ubuntu 20.04
SQL
7 votes216 views1 answer
Oracle pagination query rownum
SQL
0 vote184 views1 answer
Get employees if not contains in sql
SQL
0 vote207 views1 answer
Sql query interview questions githu
SQL
1 vote212 views1 answer
Oracle select row max date
SQL
0 vote226 views1 answer
Sql anywhere create procedure
SQL
0 vote148 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote243 views1 answer
Mysql trigger to delete old data
SQL