A subquery,except one in the FROM clause,cannot contain a(n)____ clause.
A) GROUP BY
B) HAVING
C) ORDER BY
D) WHERE

Question

A subquery,except one in the FROM clause,cannot contain a(n)____ clause.​
A) ​GROUP BY
B) ​HAVING
C) ​ORDER BY
D) ​WHERE

Quizplus · Accepted Answer

Subqueries, except those in the FROM clause (which are actually derived tables or subselects), cannot contain an ORDER BY clause. The ORDER BY clause is used to sort the result set of a query by one or more columns and is typically used in the outermost SELECT statement. The purpose of a subquery is to return data to the enclosing query, and ordering this data inside the subquery usually has no effect on the final result of the main query, hence it's not allowed. Exceptions exist when using certain clauses like TOP or LIMIT within the subquery, but generally, ORDER BY is not used within subqueries.

A Subquery,except One in the FROM Clause,cannot Contain A(n)____ Clause