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

0 vote146 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
1 vote140 views1 answer
Install postgresql on raspberry pi
SQL
37 votes136 views3 answers
Duplicate records in sql
SQL
0 vote130 views1 answer
Add column in sql server ubuntu
SQL
0 vote141 views1 answer
Stratified sampling sql
SQL
0 vote196 views1 answer
How to add auto increment primary key
SQL
3 votes157 views1 answer
Set default today mysql
SQL
0 vote139 views1 answer
Open postgresql.conf in centos
SQL
-1 vote150 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote121 views1 answer
Name '_mysql' is not defined
SQL