A view can be created as read only.

A view can be created as a join on two or more tables. AND Insert and delete operations cannot be performed on views using functions

A view cannot have an ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.