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 vote135 views1 answer
Mariadb maximum left join
SQL
1 vote147 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
6 votes221 views1 answer
Sql insert values into table
SQL
0 vote146 views1 answer
Where date in datetime mysql
SQL
2 votes129 views1 answer
Oracle sql day of month from date
SQL
3 votes148 views2 answers
How to start postgresql on windows
SQL
0 vote142 views1 answer
Change filed order in mysql
SQL
24 votes132 views6 answers
Rename a column in sql server
SQL
23 votes135 views6 answers
Delete all rows from table sql
SQL
25 votes160 views1 answer
How to update an attribute in MySQL
SQL