Sql row having max

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 vote330 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote301 views1 answer
Save single sql query result boolean spring boot
SQL
5 votes337 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote337 views1 answer
Like sql for second letter of the family name
SQL
0 vote371 views1 answer
Oracle winter time change
SQL
3 votes350 views1 answer
Start mysql server linux terminal
SQL
0 vote317 views3 answers
Get count of null in column sql
SQL
0 vote353 views1 answer
Sql date with year
SQL
5 votes337 views1 answer
Oracle sysdate - 1 month
SQL
0 vote318 views1 answer
Complete date is 1 year or not sql server
SQL