Question

List the different types of views​

Answer 1

Answer:

There are 2 types of Views in SQL: Simple View and Complex View. Simple views can only contain a single base table. Complex views can be constructed on more than one base table. In particular, complex views can contain: join conditions, a group by clause, a order by clause.

Answer 2

Answer:

The different types of views are:-

1. Simple view

2. Complex view