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 vote380 views1 answer
Sqlite woth cmake
SQL
0 vote379 views1 answer
Modifier une valeur sql
SQL
1 vote372 views1 answer
Regular expression in sql server
SQL
1 vote343 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote376 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote366 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote453 views1 answer
Run docker container with database as rds metabase
SQL
0 vote386 views1 answer
Sql query to force the database to be drop
SQL
4 votes371 views2 answers
Oracle unlock account
SQL
0 vote371 views1 answer
Mysql bash execute sql file
SQL