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

0 vote272 views1 answer
Soql user profile
SQL
3 votes290 views1 answer
Only join in sql
SQL
0 vote266 views2 answers
Create new table plsql
SQL
18 votes276 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote261 views2 answers
How to see table associated with a schema in sql
SQL
0 vote280 views1 answer
Insert output identity
SQL
0 vote261 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
1 vote278 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote273 views1 answer
Sql server size of every table in a db
SQL
0 vote256 views1 answer
INSERT INTO table using OpenQuery
SQL