/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 vote301 views1 answer
Remove default constraint sql server
SQL
0 vote362 views1 answer
Fetching data from mysqldb
SQL
19 votes317 views5 answers
Change column name mysql command line
SQL
3 votes329 views2 answers
To_char sql
SQL
6 votes308 views2 answers
Mysql version check cmd
SQL
0 vote329 views1 answer
Mysql set variable to today's date
SQL
0 vote293 views1 answer
Mysql date + 1 day
SQL
0 vote311 views1 answer
Sqlplus change user
SQL
0 vote320 views1 answer
Change redo log file size in mysql 5.6
SQL
2 votes315 views1 answer
Oracle drop sequence if exists
SQL