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

5 votes129 views2 answers
Oracle list columns schema
SQL
0 vote171 views1 answer
Table user postgres
SQL
1 vote221 views1 answer
Oracle datafile max size 32gb
SQL
0 vote163 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote145 views1 answer
How to select only a certain date sql
SQL
0 vote150 views1 answer
Sql shell psql cannot enter password
SQL
0 vote143 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote197 views1 answer
Mysql show foreign keys column
SQL
0 vote159 views1 answer
Mysql pv progres
SQL
10 votes145 views4 answers
Sql pagination
SQL