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

4 votes265 views1 answer
SQL order random
SQL
0 vote321 views1 answer
Gcloud sql list databases
SQL
3 votes271 views1 answer
Search for column name in psql
SQL
0 vote290 views1 answer
Test sql query
SQL
0 vote366 views2 answers
Insert data into multiple tables mysql
SQL
0 vote268 views1 answer
Database springboot
SQL
-1 vote298 views1 answer
Can pandas fetch data from sql
SQL
0 vote297 views1 answer
Mssql + bit + in python orm
SQL
0 vote329 views1 answer
Postgres - Login and connect as default user
SQL
0 vote272 views1 answer
Mysql group by derived column
SQL