SQL Subquery Exercises: Find the names of departments with more than two employees are working

SQL SUBQUERY: Exercise-38 with Solution

38. From the following tables write a SQL query to find which departments have more than two employees. Return dpt_name.

Sample table: emp_department

Sample table: emp_details

Sample Solution:

SELECT dpt_name FROM emp_department
  WHERE dpt_code IN
  (
    SELECT emp_dept
      FROM emp_details
      GROUP BY emp_dept
      HAVING COUNT(*) >2
  );

Output of the Query:

dpt_name
IT
HR
Finance

Pictorial Presentation:

Practice Online

Sample Database:

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following tables, write a SQL query to find the departments where the sanction amount is higher than the average sanction amount of all the departments. Return dpt_code, dpt_name and dpt_allotment.
Next: From the following tables, write a SQL query to find the departments where the sanction amount is second lowest. Return emp_fname and emp_lname.