/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

5 votes177 views5 answers
Sqlite install python
SQL
0 vote169 views2 answers
Sql regex vowel
SQL
3 votes161 views1 answer
How to remove characters from string in mysql
SQL
1 vote181 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote162 views1 answer
Mysql select where text contains
SQL
0 vote162 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
4 votes174 views4 answers
Start mysql
SQL
18 votes173 views3 answers
Mysql add column default value
SQL
1 vote184 views1 answer
Too many connections mysql
SQL
3 votes177 views2 answers
Postgres download
SQL