Sub-queries can be nested in…
DELETE statements only.
INSERT statements only.
UPDATE statements only.
UPDATE, DELETE, INSERT and SELECT statements.