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

6 votes197 views3 answers
Update with inner join postgres
SQL
0 vote182 views1 answer
Mysql with
SQL
0 vote257 views1 answer
Oracle job session
SQL
6 votes192 views2 answers
If not exists insert sql
SQL
0 vote209 views1 answer
Select new table sql
SQL
3 votes175 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote234 views1 answer
Sqlite3 not commit
SQL
0 vote229 views1 answer
Get initial in sql
SQL
0 vote219 views3 answers
Join
SQL
0 vote186 views1 answer
Sql datediff db2
SQL