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:

SQL Subqueries: 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.

Practice Online


Query Visualization:

Duration:

Query visualization of 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 - Duration

Rows:

Query visualization of 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 - Rows

Cost:

Query visualization of 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 - Cost

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

Previous: From the following table, write a SQL query to find departments for a particular location. The location matches the location of the department of ID 30. Return department name and department ID.
Next: From the following table, write a SQL query to find those employees whose salary matches to the salary of the employee who works in that department of ID 40. Return first name, last name, salary, and department ID.

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