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 vote277 views1 answer
Alter database name script
SQL
0 vote195 views1 answer
Optimize sql query
SQL
0 vote193 views1 answer
How to check xampp mysql password
SQL
0 vote232 views1 answer
Replace \n sql
SQL
3 votes260 views1 answer
Apex call duration
SQL
1 vote152 views1 answer
Oracle character set
SQL
0 vote247 views1 answer
Sql tablo sp
SQL
3 votes340 views2 answers
Oracle sql first day of month
SQL
0 vote192 views3 answers
Get free card roblox
SQL
2 votes209 views2 answers
How to run postgresql in linux
SQL