Why create view in database?

A View is similar to a Table and can be mistaken for a table by a novice application developer.

CREATE VIEW VIEW_NAME AS SQL QUERY

Here the SQL Query includes the Select query on a table that is to be displayed as a View.

The view is a read only structure that only displays contents from a table and the user cannot insert or update or delete any data in the underlying table.

Views are generally created to impose access restrictions to a specific subset of users whom you do not want to give full access but at the same time want them to view the data.