/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

1 vote268 views1 answer
Sql server epoch to datetime
SQL
8 votes261 views1 answer
Oracle add months to sysdate
SQL
0 vote259 views1 answer
Rabbitmq ui not working
SQL
1 vote246 views1 answer
Mysql server does not start mac
SQL
1 vote278 views1 answer
Hackerrank sql test solutions
SQL
0 vote279 views1 answer
Write a query to peint the pattern P(20)
SQL
13 votes261 views4 answers
Mysql select last 10 rows
SQL
150 votes477 views10 answers
Grepper
SQL
1 vote264 views1 answer
Raw query must include primary key
SQL
0 vote253 views1 answer
Postgres select except
SQL