﻿ SQL SUBQUERIES: Find employees who work for the department in which employee ID 201 is employed - w3resource

# SQL Subquery Exercises: Display the first and last name, salary, and department ID for all those employees who work in that department where the employee works who hold the ID 201

## SQL SUBQUERY: Exercise-39 with Solution

From the following table, write a SQL query to find employees who work for the department in which employee ID 201 is employed. Return first name, last name, salary, and department ID.

Sample table: employees

Sample Solution:

``````SELECT first_name, last_name, salary, department_id
FROM employees
WHERE department_id =
(SELECT department_id
FROM employees
WHERE employee_id = 201);
``````

Sample Output:

```first_name	last_name	salary	department_id
Michael		Hartstein	13000.00	20
Pat		Fay		6000.00		20
```

Pictorial Presentation:

## Query Visualization:

Duration:

Rows:

Cost:

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

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿

## SQL: Tips of the Day

"where 1=1" statement?

It's usually when folks build up SQL statements.

When you add and value = "Toyota" you don't have to worry about whether there is a condition before or just WHERE.

Ref: https://bit.ly/3cayyhJ