A subquery in an SQL SELECT statement is enclosed in:

• braces -- {...}.
• CAPITAL LETTERS.
• parenthesis -- (...) .
• brackets -- [...].