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 vote181 views1 answer
Clone table structure mysql
SQL
1 vote209 views2 answers
Login to mysql
SQL
0 vote204 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote189 views1 answer
Rollback to name in sql
SQL
5 votes235 views2 answers
Postgresql add not null constraint
SQL
6 votes204 views4 answers
Eloquent to sql with bindings
SQL
2 votes154 views1 answer
Oracle current date without time
SQL
1 vote196 views1 answer
Sql delete all values in a column
SQL
0 vote218 views1 answer
Postgresql combine values in one field
SQL
22 votes206 views4 answers
Tsql rename table
SQL