Question

Retrieve the names of all employees who work in the department that has the employee with the lowest salary among all employees

Answer 1

Answer:

I have two tables

EMPLOYEE (Fname, Lname, Ssn, Salary, Dno)

DEPARTMENT (Dname, Dno, Location)

I want to list the names of all employees making the least in their department

I have come up with this

select min(E.Salary) from EMPLOYEE E group by E.Dno;

but how do I join the EMPLOYEE table with it and display the 'Fname' and 'Lname';