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

3 votes140 views2 answers
Oracle apex charging debug
SQL
0 vote134 views1 answer
Mysql concat and use as where column
SQL
27 votes164 views6 answers
Set password mysql
SQL
14 votes144 views2 answers
Sql cast
SQL
0 vote141 views2 answers
Nosqlbooster query other collection
SQL
0 vote131 views1 answer
Possgress drop if exists view
SQL
0 vote149 views1 answer
St_buffer mysql
SQL
0 vote147 views1 answer
Open postgresql.conf in centos
SQL
0 vote160 views1 answer
Create a plsql object
SQL
6 votes179 views5 answers
Oracle list tablespaces
SQL