View is a virtual table with no data , but can be operated like
any other table. It is like a virtual table through which you can
view data of another table, which is known as the base table.
Syntax for creating a view- CREATE VIEW as SELECT statement ;