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 vote239 views1 answer
Mysql query problems and solutions
SQL
18 votes232 views6 answers
Mysql create table
SQL
11 votes266 views6 answers
Mysql else if
SQL
19 votes246 views2 answers
Mysql tinyint max value
SQL
0 vote233 views1 answer
Mysql config slave
SQL
3 votes218 views3 answers
Mysqldump: couldn
SQL
34 votes233 views6 answers
Sql change data type
SQL
0 vote238 views2 answers
Oracle sql for each row
SQL
2 votes254 views1 answer
Postgresql create schema in specific database
SQL
1 vote245 views1 answer
Sysdate in sql
SQL