Sql select lowest value 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

10 votes210 views6 answers
Between sql
SQL
0 vote201 views1 answer
Tsql cmd exec script from file
SQL
0 vote212 views1 answer
Mysql error 1251
SQL
0 vote229 views1 answer
Get null value in sql
SQL
2 votes217 views1 answer
Mysql select true or false
SQL
0 vote209 views1 answer
Psql check table fields
SQL
0 vote200 views1 answer
Drop all triggers oracle
SQL
2 votes211 views4 answers
2nd highest salary in mysql
SQL
1 vote195 views2 answers
Sql convert datetime to year month
SQL
0 vote184 views1 answer
Oracle list of long running queries
SQL