Sql select lowest 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 vote357 views1 answer
Mysql terminal run sql file
SQL
22 votes343 views3 answers
Sql cheat sheet
SQL
0 vote358 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote367 views1 answer
Flexible search query delete table
SQL
0 vote298 views1 answer
Oracle sql developer script output limit
SQL
7 votes367 views4 answers
What is my mysql version
SQL
0 vote380 views1 answer
Mysql faster delete
SQL
0 vote352 views1 answer
Oracle query archivemode
SQL
0 vote402 views1 answer
Hashpass
SQL
2 votes367 views1 answer
How to delete all duplicate items in mysql
SQL