mysql min value row

Solutions on MaxInterview for mysql min value row by the best coders in the world

showing results for - "mysql min value row"
Maria
23 Jan 2019
1SELECT t1.*
2FROM employees t1
3INNER JOIN (
4    SELECT id, min(salary) AS salary FROM employees GROUP BY id
5) t2 ON t1.id = t2.id AND t1.salary = t2.salary;