/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

1 vote213 views4 answers
Fatal database postgres does not exist
SQL
0 vote224 views1 answer
How to retrive the today date sql
SQL
1 vote219 views1 answer
Create index concurrently postgres
SQL
0 vote247 views1 answer
Mysql insert into select transaction c#
SQL
0 vote221 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
1 vote229 views1 answer
Mysql tables max count
SQL
1 vote353 views3 answers
Create table from existing table in sql
SQL
16 votes250 views2 answers
Mysql date between two dates
SQL
15 votes238 views4 answers
Mysql export database command line
SQL
1 vote301 views1 answer
Mysql get max value and id
SQL