According to the SQL-92 standard,statements used to construct views cannot contain ________.
A)the SELECT clause
B)the FROM clause
C)the WHERE clause
D)the ORDER BY clause

Question

Quizplus · Accepted Answer

According to the SQL-92 standard, statements used to construct views can contain the SELECT, FROM, and WHERE clauses. However, they cannot contain the ORDER BY clause. The ORDER BY clause can only be used in the outermost query that references the view.

According to the SQL-92 Standard,statements Used to Construct Views Cannot