Sql row having max

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

2 votes135 views1 answer
Create delete procedure mysql
SQL
0 vote124 views1 answer
How to reset table in sql server
SQL
8 votes119 views2 answers
Mysql query dates between two dates
SQL
0 vote136 views1 answer
Sqlalchemy get schema from database
SQL
3 votes129 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote132 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote91 views1 answer
Raven ql select count
SQL
0 vote138 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote147 views1 answer
Sql select first and last record of each group
SQL
1 vote126 views1 answer
Mysql count words
SQL