/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

4 votes287 views1 answer
Mysql store ip address
SQL
3 votes176 views1 answer
Start mysql server linux terminal
SQL
0 vote171 views5 answers
Sql table intermédiaire
SQL
-1 vote181 views2 answers
Postgresql user permissions to database
SQL
0 vote177 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote256 views1 answer
Sql delete caracter list
SQL
0 vote177 views2 answers
Postgresql change user role grant
SQL
1 vote210 views1 answer
Convert to hexadecimal sql
SQL
3 votes226 views2 answers
Search text in all sql server stored procedure
SQL
2 votes197 views1 answer
Mysql time ago difference
SQL