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

16 votes139 views3 answers
T-SQL Add Column
SQL
0 vote130 views1 answer
Go install mysql
SQL
6 votes126 views1 answer
Oracle trigger after connect
SQL
0 vote123 views1 answer
Dump only schema
SQL
0 vote164 views1 answer
Alter domain sql
SQL
0 vote119 views1 answer
Import sql mysql ubuntu
SQL
2 votes134 views1 answer
Update trigger
SQL
10 votes136 views3 answers
Insert into auto increment mysql
SQL
0 vote128 views1 answer
Backup a table in sql
SQL
20 votes134 views3 answers
SQL query rename table
SQL