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 vote363 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote323 views1 answer
Oracle change password expiration policy
SQL
6 votes373 views4 answers
Mysql get random row
SQL
0 vote317 views2 answers
Sql trigger difference between for and after
SQL
10 votes317 views2 answers
Linux command line import mysql database
SQL
17 votes321 views6 answers
MySQL ORDER BY
SQL
2 votes322 views1 answer
Mysql now format
SQL
11 votes317 views3 answers
Sqlite3 create table from another table
SQL
0 vote306 views1 answer
View to table
SQL
1 vote316 views1 answer
Show all event schedular on mysql
SQL