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 vote226 views1 answer
Mysql if example
SQL
0 vote286 views1 answer
How to create notes in mysql
SQL
5 votes274 views4 answers
Upload database mysql command line
SQL
0 vote265 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote270 views1 answer
Sqlite löschen einer tabelle
SQL
6 votes261 views5 answers
Sql add months to date
SQL
0 vote295 views1 answer
How to check rollback status in oracle
SQL
0 vote277 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote272 views1 answer
Mysql 8 geo to json
SQL
0 vote247 views1 answer
Get last updated row sql server
SQL