/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 vote358 views1 answer
Copy data from cell to cell mysql
SQL
0 vote343 views1 answer
Select count postgres double row count > 1
SQL
51 votes452 views6 answers
Change column name sql
SQL
0 vote361 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote325 views1 answer
Oracle archivemode
SQL
-1 vote333 views1 answer
Ssms connect with connection string
SQL
8 votes337 views1 answer
Insert a select statement into a table
SQL
5 votes362 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes330 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote347 views1 answer
How to use lower case in mysql
SQL