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

1 vote215 views2 answers
Postgresql check privileges on schema
SQL
0 vote184 views1 answer
Double in sql server example
SQL
0 vote194 views1 answer
Mssql view column data type
SQL
1 vote197 views1 answer
Mysql select if empty result
SQL
4 votes186 views1 answer
Select nls_date_format
SQL
2 votes208 views1 answer
Q operator in oracle
SQL
0 vote187 views1 answer
Oracle create package specification
SQL
8 votes228 views2 answers
Default sql server port
SQL
1 vote186 views1 answer
Set statistics on in ssms
SQL
0 vote210 views1 answer
Migration graphql
SQL