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

15 votes198 views6 answers
Laravel db transaction
SQL
2 votes171 views1 answer
Oracle table size
SQL
0 vote176 views7 answers
10 random questions use python and SQL
SQL
0 vote175 views1 answer
Google sheets data validation custom formula filter
SQL
1 vote208 views1 answer
Sql select sum group by id laravel
SQL
4 votes171 views1 answer
Update table from another table oracle
SQL
0 vote174 views1 answer
Convert sql server guid to varbinary
SQL
-2 votes194 views1 answer
Trunc in sql
SQL
0 vote182 views2 answers
Php convert dbf to mysql
SQL
1 vote174 views1 answer
Convert rows to string sql server
SQL