/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 vote157 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote180 views2 answers
Nested query
SQL
36 votes157 views6 answers
Rename table sql
SQL
0 vote170 views1 answer
Postgres meta command to show all rows in table
SQL
3 votes147 views2 answers
Update Query in SQL Server
SQL
0 vote163 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote176 views1 answer
Oracle user last connection date
SQL
10 votes195 views1 answer
Oracle all_dependencies
SQL
11 votes193 views2 answers
Having keyword sql
SQL
0 vote168 views3 answers
Insert query in ci
SQL