w3resource

PostgreSQL Subquery: Find the names of the employees who works in the IT department


2. Write a SQL subquery to find the first_name and last_name of all employees who works in the IT department.

Sample Solution:

Code:

SELECT first_name, last_name 
FROM employees 
WHERE department_id 
IN (SELECT department_id 
FROM departments 
WHERE department_name='IT');

Sample table: employees


Output:

pg_exercises=# SELECT first_name, last_name
pg_exercises-# FROM employees
pg_exercises-# WHERE department_id
pg_exercises-# IN (SELECT department_id
pg_exercises(# FROM departments
pg_exercises(# WHERE department_name='IT');
 first_name | last_name
------------+-----------
 Alexander  | Hunold
 Bruce      | Ernst
 David      | Austin
 Valli      | Pataballa
 Diana      | Lorentz
(5 rows)

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to find the first_name, last_name and salaries of the employees who have a higher salary than the employee whose last_name is Bull.
Next: Write a SQL subquery to find the first_name and last_name of the employees under a manager who works for a department based in the United States.

What is the difficulty level of this exercise?



Share this Tutorial / Exercise on : Facebook and Twitter