A subquery in an SQL SELECT statement is enclosed in
By BYJU'S Exam Prep
Updated on: September 25th, 2023
A subquery in an SQL SELECT statement is enclosed in:
- Braces-{…}.
- CAPITAL LETTERS.
- Parenthesis-(…).
- Brackets-[…].
Answer: Option C. Parenthesis-(…)
A subquery in an SQL SELECT statement is enclosed in parenthesis-(…).
Solution
A subquery in an SQL SELECT statement is enclosed in parenthesis-(…). In SQL, to enclose a subquery within a query, only parenthesis are used. To enclose subquery in SQL, brackets, braces, and capital letters are never used. However, SQL commands are written in capital letters for the convenience of the user to differentiate between data and SQL commands. Following is the syntax of enclosing a subquery within a query:
SELECT columnname
FROM tablename
WHERE columnname operator
(
SELECT columnname
FROM tablename
WHERE condition
);
☛ Related Questions:
