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 vote214 views1 answer
How to delete a record from sqlite in android
SQL
1 vote202 views1 answer
How to delete record sql delphi
SQL
1 vote201 views2 answers
Limit sqlserver
SQL
0 vote243 views1 answer
New rails app with mysql
SQL
0 vote221 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote221 views1 answer
Mysql update table from select on another table
SQL
0 vote220 views1 answer
Group by sql not ordering issues
SQL
8 votes233 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote212 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote245 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL