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

20 votes159 views1 answer
Get all table name in sql through php
SQL
0 vote173 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote164 views1 answer
Date datatype in livesql
SQL
0 vote180 views1 answer
Top 3 salary in sql
SQL
0 vote170 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote167 views1 answer
Psql filed name alter
SQL
0 vote169 views1 answer
C# check if mysql query modified rows
SQL
5 votes166 views1 answer
How to check nls timestamp format in oracle
SQL
16 votes184 views2 answers
Oracle ddl
SQL
35 votes201 views5 answers
Sql alter column
SQL