Vidyalelo
SQL · Q61

SQL

Programming · SQL · question 61

Q61

A subquery in an SQL SELECT statement is enclosed in:

A.
parenthesis -- (...).
Answer
B.
brackets -- [...].
C.
CAPITAL LETTERS.
D.
braces -- {...}.

Answer: Option A

Solution

Answer: Option A
Solution:
In SQL, a subquery is enclosed in parentheses, as shown in Option A. Subqueries are used to retrieve data from one table and use that data as a condition for another query. The syntax for subqueries requires using parentheses to enclose the subquery within the main query. Options B, C, and D do not represent the correct way to enclose subqueries in SQL.