what is view ?

view is the virtual table

A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables which depends on the written SQL query to create a view.

View is virtual table based on record set of select statement. If we have several tables in a db and we want to view only specific columns from specific tables we can go for views