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

0 vote133 views1 answer
Install mysql for fedora 34
SQL
0 vote141 views1 answer
Sql quary intervewi question
SQL
0 vote155 views2 answers
Athena drop partition
SQL
0 vote156 views1 answer
Sql query tags
SQL
0 vote149 views1 answer
Mysql pad zeros
SQL
0 vote143 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote172 views1 answer
Check database restore status sql script
SQL
0 vote194 views1 answer
Radius search with point data in mysql
SQL
0 vote149 views3 answers
How to run sql query
SQL
0 vote140 views2 answers
Mysql update two tables at once
SQL