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 vote350 views1 answer
Database timezone
SQL
0 vote342 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote315 views2 answers
How to combine two sql queries in one result
SQL
2 votes430 views3 answers
Sql delete duplicate
SQL
0 vote365 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote351 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote366 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote371 views1 answer
Mysql Selected All Duplicate Rows
SQL
-2 votes357 views1 answer
Use of where in left join in mysql
SQL
2 votes384 views1 answer
Mysql set value as null
SQL