/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 vote128 views1 answer
Savepoint mysql script
SQL
0 vote112 views1 answer
Get the previous column of a table in mysql
SQL
1 vote162 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote106 views2 answers
List all constraints in postgres
SQL
0 vote111 views1 answer
Query for backup a database at another location in file system
SQL
0 vote113 views1 answer
What is top n result in sql
SQL
14 votes109 views1 answer
Oracle new column
SQL
0 vote101 views1 answer
Python sql last insertend
SQL
0 vote110 views1 answer
H2 auto increment and unique
SQL
3 votes98 views1 answer
Oracle failed login attempts
SQL