Mysql min 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

-1 vote121 views2 answers
First letter capital in mysql query
SQL
0 vote114 views2 answers
Imageview setimageresource null
SQL
-1 vote135 views1 answer
Sql show custom constraints
SQL
1 vote110 views1 answer
Set id count mysql
SQL
0 vote113 views1 answer
Array aggre distinct postgres
SQL
0 vote130 views1 answer
Sql remove non numeric characters
SQL
0 vote171 views1 answer
Sql ssrs
SQL
19 votes127 views6 answers
Mysql if null
SQL
0 vote130 views1 answer
Sql getdate minus 1 day without time
SQL
57 votes279 views5 answers
How to create a new user in postgresql
SQL