/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 vote205 views2 answers
Drop function in sql
SQL
0 vote207 views1 answer
T sql less than date
SQL
7 votes215 views3 answers
SQL create a new table
SQL
0 vote217 views1 answer
To_date sql
SQL
3 votes212 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
10 votes208 views6 answers
Sql between
SQL
0 vote191 views1 answer
Mysql local password denied
SQL
0 vote203 views4 answers
Change schema in sql server
SQL
0 vote243 views1 answer
How to get table id sequence postgres
SQL
4 votes209 views1 answer
Conda install sqlalchemy
SQL