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

13 votes198 views2 answers
Oracle inner join
SQL
2 votes197 views3 answers
Application.properties spring boot mysql
SQL
1 vote179 views1 answer
Postgresql escape single quote
SQL
0 vote189 views1 answer
Createdb with postgresql on ubuntu
SQL
1 vote190 views1 answer
Mysql select if empty result
SQL
2 votes168 views1 answer
How to find constraints on a table in oracle
SQL
-1 vote166 views1 answer
How to check table exists or not in postgresql
SQL
2 votes176 views3 answers
Postgresql reset auto increment
SQL
0 vote126 views1 answer
How to set field to null in sql
SQL
0 vote133 views0 answer
SQL