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