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

0 vote150 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote131 views1 answer
Postgres create extension if not exists
SQL
0 vote133 views1 answer
Python sql last insertend
SQL
0 vote294 views1 answer
Current month transactions in mysql
SQL
0 vote131 views1 answer
Oracle list datafiles
SQL
0 vote201 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote123 views1 answer
Sql server select rows by distinct column
SQL
3 votes121 views2 answers
Mysql add 2 hours
SQL
0 vote133 views1 answer
Will graphql replace sql
SQL
5 votes140 views1 answer
Oracle list packages
SQL