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 vote261 views1 answer
Sql select inside select sub query
SQL
2 votes257 views1 answer
Oracle trace session
SQL
2 votes280 views4 answers
Check timezone of mysql database
SQL
0 vote262 views1 answer
Mariadb maximum left join
SQL
4 votes282 views3 answers
Sql drop primary key
SQL
6 votes259 views3 answers
Mysql change auto_increment start value
SQL
10 votes278 views4 answers
Primary key in sql
SQL
2 votes263 views3 answers
Mysql list tables by size
SQL
0 vote267 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
3 votes364 views1 answer
How to get yesterday date in sql
SQL