/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 vote125 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote125 views1 answer
How to select only id where is not in column mysql
SQL
0 vote141 views1 answer
SQL Server date literal
SQL
3 votes195 views1 answer
Sql add two values together
SQL
0 vote84 views1 answer
Mysql find foreign key references
SQL
0 vote115 views1 answer
What are the aggregate function in sql
SQL
3 votes134 views1 answer
Insert into table from another table mysql
SQL
0 vote117 views1 answer
Sql clear table
SQL
0 vote126 views1 answer
Sql recherche nom prenom
SQL
-1 vote155 views1 answer
Add 10 to all numbers in a column sql
SQL