Introduction
Very simple subqueries
Subqueries with multiple results
Correlated subqueries
Instruction
Excellent! Subqueries can also be used with other logical operators. Take a look at the following example:
SELECT
*
FROM Mountain
WHERE Height > (
SELECT
Height
FROM Mountain
WHERE Name = N'Zugspitze'
);
The above query will return all mountains that are taller than Zugspitze. As you can see, we've used the greater-than operator (>) within the subquery.
Exercise
Find the names of all cities that have a population less than that of Madrid.
Stuck? Here's a hint!
Type:
SELECT
City.Name
FROM City
WHERE City.Population < (
SELECT
City.Population
FROM City
WHERE City.Name = N'Madrid'
);
