COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
braces ____ { ____ }.
|
|
|
CAPITAL LETTERS.
|
|
|
parenthesis ____ ( ____ ) .
|
|
|
brackets ____ [ ____ ].
|
Detailed explanation-1: -a subquery must be enclosed in the parenthesis. a subquery must be put in the right hand of the comparison operator, and. a subquery cannot contain a ORDER-BY clause.
Detailed explanation-2: -A subquery (the inner SELECT statement, where one SELECT statement is nested within another) can return zero or more rows or expressions. Each subquery must be delimited by parentheses, and must contain a Projection clause and a FROM clause.
Detailed explanation-3: -A subquery can be placed in a number of SQL clauses like WHERE clause, FROM clause, HAVING clause. You can use Subquery with SELECT, UPDATE, INSERT, DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN, etc. A subquery is a query within another query.