/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 vote159 views1 answer
Xampp mysql version
SQL
0 vote181 views1 answer
Codigo crear tablas sql server
SQL
3 votes191 views4 answers
Mysql create table from select statement
SQL
0 vote150 views1 answer
Select from another database
SQL
0 vote200 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote169 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
4 votes168 views1 answer
Mysql ip address data type
SQL
0 vote116 views2 answers
Sql query unique
SQL
0 vote156 views1 answer
Inserted row count tsql
SQL
0 vote211 views1 answer
Oracle temporary table
SQL