Sql select min row

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, min(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

2 votes150 views1 answer
Enum in SQL Server
SQL
16 votes147 views4 answers
Ascending order mysql
SQL
0 vote165 views1 answer
Rabbitmq service not starting
SQL
0 vote140 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote141 views2 answers
Mysql show views
SQL
0 vote142 views1 answer
Vowels in sql
SQL
1 vote144 views1 answer
Crontab every month
SQL
0 vote99 views1 answer
Oracle list all stored procedures
SQL
0 vote145 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote151 views2 answers
Alter table add multiple columns mysql
SQL