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 vote211 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote227 views2 answers
Sql auto update dupdated_at
SQL
8 votes219 views3 answers
Connect python to mysql
SQL
1 vote205 views1 answer
Oracle apex version view
SQL
0 vote207 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
3 votes209 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote219 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote213 views1 answer
Mysql get domain from url
SQL
2 votes216 views2 answers
Spring import sql
SQL
0 vote223 views1 answer
Select nth row in mysql
SQL