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 vote299 views1 answer
Mysql date without time
SQL
1 vote283 views1 answer
Create another table from existing table sql oracle
SQL
5 votes248 views1 answer
Mysql select greater than yesterday
SQL
0 vote288 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote273 views1 answer
Ksql quickstart docker
SQL
0 vote259 views1 answer
Mysql export data with a where clause
SQL
1 vote290 views1 answer
Mysql check if string contains comma separated
SQL
2 votes269 views1 answer
SQL column name Postgre
SQL
8 votes287 views2 answers
Sqlsrv default port
SQL
0 vote273 views1 answer
How to output a different column name in mysql
SQL