Sql select whole row max column

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 vote129 views1 answer
Get foreign table names mysql
SQL
0 vote137 views1 answer
Mariadb create index if not exists
SQL
0 vote139 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
7 votes212 views1 answer
Oracle alter sequence restart start with
SQL
0 vote133 views1 answer
How to create notes in mysql
SQL
0 vote101 views1 answer
Sql injection mitigation
SQL
25 votes126 views6 answers
Modify column name in mysql
SQL
1 vote141 views1 answer
Sqlite3 read only
SQL
0 vote131 views1 answer
Search db for table name
SQL
3 votes127 views1 answer
Select count from table mysql
SQL