Deleting with a Subquery
Working with Subqueries
Filtering with a Subquery
Filtering with a CTE
Filtering with EXISTS
Subqueries as Calculated Fields
Subquery in a JOIN
Updating with a Subquery
Deleting with a Subquery
DELETE
FROM
country
WHERE
NOT
EXISTS
(
SELECT
1
FROM
city
WHERE
city.
CountryCode
= country.
Code
)
Deleting countries without cities.