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 vote272 views1 answer
Sql server isnull function nor working count
SQL
8 votes274 views1 answer
Oracle tablespace datafile max size
SQL
0 vote259 views1 answer
Sql if else in select
SQL
0 vote268 views1 answer
Conda install pymysql "windows"
SQL
1 vote270 views1 answer
Sql convert month name to number
SQL
0 vote306 views1 answer
Date 3 months from today sql
SQL
0 vote260 views1 answer
Back up stored procedures mysql
SQL
0 vote263 views1 answer
Mariadb mysql root access denied
SQL
0 vote287 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote279 views1 answer
How to login to mysql in homestead
SQL