/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 vote319 views2 answers
Maximum number of tables in mysql
SQL
9 votes313 views1 answer
Alter table column change data type to text mysql
SQL
1 vote346 views1 answer
How not to sort by average rating
SQL
0 vote345 views1 answer
Oracle winter time change
SQL
0 vote305 views2 answers
Uninstall postgresql mac
SQL
0 vote307 views2 answers
Mysql on update current_timestamp
SQL
15 votes540 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote342 views1 answer
Oracle select first row order by
SQL
7 votes281 views1 answer
Query delete duplicates
SQL
0 vote281 views1 answer
Sql auto_increment syntax
SQL