Find employees in a specific department
Which SQL query retrieves the employee numbers of all employees working in department 'd002'?

Question

Find employees in a specific department 
 Which SQL query retrieves the employee numbers of all employees working in department 'd002'?

Accepted Answer

SELECT emp_no FROM dept_emp WHERE dept_no = 'd002';

Answer

SELECT emp_no FROM departments WHERE dept_no = 'd002';

Answer

SELECT emp_no FROM salaries WHERE dept_no = 'd002';

Answer

SELECT dept_no FROM employees WHERE dept_no = 'd002';

Crowdly