Sql row having max

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 vote248 views1 answer
Many rows to 1 string mysql
SQL
0 vote197 views1 answer
List mysql tables and views
SQL
0 vote188 views1 answer
How to select all fieldsin a soql query
SQL
10 votes252 views2 answers
Reset mysql root password mac
SQL
0 vote217 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote198 views2 answers
How to generate a unique random number in mysql
SQL
0 vote196 views2 answers
Sql query inner join 3 tables
SQL
1 vote198 views1 answer
How to group by month using sql server
SQL
1 vote244 views1 answer
Oracle check table lock
SQL
3 votes197 views3 answers
How to set up an auto incrementing id db browser
SQL