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 votes145 views1 answer
Sql multi column index performance
SQL
4 votes140 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
3 votes137 views1 answer
Sql print all names that start with a given letter
SQL
1 vote135 views1 answer
Update from select join
SQL
19 votes137 views6 answers
Laravel sql query
SQL
0 vote151 views1 answer
Sql server isnull function nor working count
SQL
1 vote156 views1 answer
Apex select list ORA-20999
SQL
0 vote142 views1 answer
Sql dmv to capture updates
SQL
0 vote145 views1 answer
Oracle sql date winter time
SQL
1 vote148 views1 answer
Alter constraint in sql
SQL