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 vote166 views1 answer
Mysql command line ubuntu
SQL
3 votes178 views1 answer
Increment integer in table sql
SQL
1 vote181 views1 answer
Add multiple row table pl sql
SQL
0 vote167 views1 answer
Sqlite select split string
SQL
0 vote158 views1 answer
Oracle index hint multiple tables example
SQL
1 vote173 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote220 views1 answer
Sqlite trim
SQL
0 vote169 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
18 votes168 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote201 views1 answer
Create table as select sql server error
SQL