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

25 votes223 views4 answers
Sqlserver add column
SQL
0 vote243 views1 answer
Create-table-with-index-organization
SQL
0 vote211 views1 answer
Mysql replication change database name
SQL
0 vote215 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote214 views1 answer
Load sql into mamp
SQL
19 votes223 views2 answers
Mysql tinyint max value
SQL
4 votes217 views4 answers
Print pl sql
SQL
0 vote214 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
15 votes216 views1 answer
Mysql int range
SQL
1 vote236 views2 answers
Drop table with constraints
SQL