/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 vote164 views1 answer
Start and stop mysql
SQL
1 vote207 views1 answer
Oracle columns table
SQL
3 votes200 views1 answer
Set default today mysql
SQL
0 vote182 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote170 views3 answers
How to increase size of column in sql
SQL
2 votes211 views1 answer
Show max_allowed_packet mysql
SQL
9 votes161 views2 answers
Default number in sql
SQL
2 votes178 views1 answer
Docker run postgres locally
SQL
1 vote171 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote143 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL