Issue with MIN and Group BY

[karatekid36]

With the below query, it returns the MIN salary for each department, but what if you want to list the EMP_ID or EMP_NAME in this list as well? Meaning you want to see the EMP_ID in the department that has the MIN(salary).  Won't that end up expanding the returns to more or less all rows?

 

 

SELECT department, MIN(salary) as "Lowest salary"

FROM employees

GROUP BY department;

 

Thanks!

 

[fenway]

Then you need a self-join.