/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 vote152 views1 answer
For select oracle
SQL
0 vote125 views1 answer
Sql select inside select sub query
SQL
7 votes121 views2 answers
Execute mysql file
SQL
2 votes160 views1 answer
Orcale index size
SQL
0 vote121 views1 answer
UNION ALL LEFT JOIN
SQL
2 votes128 views2 answers
How to run postgresql in linux
SQL
0 vote119 views1 answer
How to use sqlcommand
SQL
13 votes116 views3 answers
Change data type postgresql
SQL
58 votes278 views6 answers
Create new user in postgres
SQL
1 vote136 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL