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 vote407 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
3 votes349 views3 answers
Create table in microsoft sql server
SQL
0 vote347 views1 answer
Delete duplicate rows
SQL
0 vote327 views1 answer
Concat column value of same user in mysql
SQL
1 vote349 views1 answer
Oracle apex version view
SQL
1 vote341 views1 answer
Mysql dump specific tables
SQL
0 vote329 views1 answer
Procedures sql insert mysql
SQL
1 vote389 views1 answer
Sql random sampling per group
SQL
0 vote340 views1 answer
Sql select max value for each group
SQL
0 vote339 views1 answer
Alter fedora mysql 8.0 user
SQL