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

1 vote192 views1 answer
Postgres set sequence value to max id
SQL
2 votes142 views1 answer
How to make insert script from table in SQL server
SQL
0 vote152 views1 answer
What logs are available on RDS MySQL?
SQL
1 vote159 views1 answer
How to give access to database in postgresql server to another user
SQL
1 vote144 views1 answer
Convert epoch to date in sql server
SQL
24 votes165 views4 answers
Delete db postgres
SQL
3 votes132 views3 answers
Mysqldump: couldn
SQL
1 vote137 views1 answer
How to install mysql 8.0 windows service
SQL
3 votes137 views1 answer
Créer une table sql
SQL
0 vote127 views5 answers
Sql table intermédiaire
SQL