Sql select whole row max column

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 vote202 views1 answer
Join in update query in mysql
SQL
0 vote217 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote225 views1 answer
Allow null in psql
SQL
3 votes182 views2 answers
Mysql create database
SQL
0 vote303 views1 answer
Site:av.ru "files"
SQL
0 vote232 views4 answers
Rownum in sql
SQL
0 vote200 views1 answer
Psql get table data types
SQL
0 vote267 views1 answer
Convert multiple columns to ROws in sql server
SQL
150 votes552 views10 answers
Grepper
SQL
0 vote198 views1 answer
Sql remove first character from string
SQL