﻿ SQL SUBQUERIES: Find those departments that are located in the city of London - w3resource

# SQL Subquery Exercises: Display the department code and name for all departments which located in the city London

## SQL SUBQUERY: Exercise-35 with Solution

From the following tables, write a SQL query to find those departments that are located in the city of London. Return department ID, department name.

Sample table: departments

Sample table: locations

Sample Solution:

``````SELECT department_id, department_name
FROM departments
WHERE location_id =
(
SELECT location_id
FROM locations
WHERE city = 'London'
);
``````

Sample Output:

```department_id	department_name
40		Human Resources
```

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