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

1 vote317 views2 answers
Snowflake alter column data type
SQL
0 vote251 views1 answer
Expose db in virtualbox
SQL
0 vote297 views1 answer
Mysql beautifier terminla
SQL
13 votes270 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
1 vote314 views1 answer
Mysql select from outside
SQL
2 votes294 views1 answer
Date conversion in mysql column
SQL
1 vote307 views1 answer
Partition by sql server
SQL
0 vote301 views1 answer
How to read the potentail error messages in ssis package
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote321 views3 answers
Condition in count sql
SQL