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 vote191 views1 answer
Check if has alpha characters sql
SQL
0 vote231 views1 answer
For select oracle
SQL
3 votes218 views2 answers
Search text in all sql server stored procedure
SQL
0 vote243 views2 answers
Wordpress change url in database
SQL
1 vote177 views1 answer
Temp table vs variable table in sql server
SQL
7 votes185 views1 answer
Mysql remote connection command line
SQL
1 vote171 views1 answer
Sql not equal multiple columns
SQL
0 vote192 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote185 views1 answer
Mysql how to reset primary key
SQL
0 vote190 views1 answer
How to install Firebird
SQL