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

27 votes315 views6 answers
Sql update record
SQL
0 vote284 views1 answer
Create column that already exists mysql
SQL
2 votes333 views1 answer
Mysql id of inserted row
SQL
0 vote311 views1 answer
Where name ends in SQL
SQL
0 vote285 views1 answer
Renommer table sql
SQL
2 votes283 views1 answer
Mysql sysdate
SQL
1 vote305 views1 answer
List all triggers in SQL Server
SQL
0 vote314 views1 answer
If column value is null then in mysql
SQL
0 vote311 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote324 views1 answer
Get initials name in sql
SQL