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 vote121 views1 answer
Criteria builder select subset of column
SQL
0 vote119 views1 answer
What is metadata in sql
SQL
3 votes129 views3 answers
Mysql declare variable
SQL
0 vote115 views1 answer
Sql menampilkan data tabel
SQL
0 vote128 views1 answer
Postgress append string in select
SQL
8 votes127 views1 answer
Declare table variable sql server
SQL
1 vote162 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote128 views1 answer
Mysql insert into select with recursive
SQL
0 vote111 views1 answer
Increment id in mysql
SQL
14 votes131 views3 answers
Oracle sql limit results
SQL