What are the differences between simple and complex views?
What will be an ideal response?
Simple View Complex View
It is based on one table. It is based on one or more tables.
It does not contain group functions. It may contain group functions.
It does not contain grouped data. It may contain grouped data.
Data manipulation is always possible Data manipulation is not always possible
Computer Science & Information Technology