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

4 votes284 views1 answer
Add constraint fk
SQL
0 vote274 views2 answers
What is 1=2 in sql
SQL
0 vote284 views1 answer
Ignore case in string sql
SQL
-1 vote273 views1 answer
Mysql coalesce
SQL
0 vote268 views1 answer
Remove from table where
SQL
0 vote289 views1 answer
Db format in quotation
SQL
0 vote283 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
5 votes324 views2 answers
Add days in oracle sql
SQL
17 votes277 views6 answers
Mysql import sql file
SQL
0 vote291 views1 answer
Custom row number
SQL