Which of the following types of views cannot include a GROUP BY clause?
A) simple view
B) inline view
C) complex view
D) all of the above clause

Question

Which of the following types of views cannot include a GROUP BY clause?​
A) ​simple view
B) ​inline view
C) ​complex view
D) ​all of the above clause

Quizplus · Accepted Answer

Simple views cannot include a GROUP BY clause. A simple view is a select statement that retrieves data from one or more tables, but it cannot have its own WHERE or GROUP BY clauses. A GROUP BY clause can only be used in a select statement that is used to create a complex view or subquery.

Which of the Following Types of Views Cannot Include a GROUP