/SQL/Mysql select row with max value group by

Mysql select row with max value group by

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

0 vote248 views1 answer
Add SuperUser MySQL
SQL
0 vote321 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote246 views1 answer
Sql describe
SQL
0 vote259 views1 answer
Mysql root localhost run
SQL
8 votes250 views1 answer
Oracle search source code
SQL
4 votes274 views3 answers
Sql drop database if exists
SQL
0 vote272 views1 answer
Postgresql create query
SQL
0 vote268 views4 answers
Open mysql port bitnami tomact
SQL
1 vote265 views1 answer
Sql server list locks
SQL
3 votes247 views1 answer
Sql datetime as date
SQL