A view provides an alternate way of looking at the data in one or more tables. It is a dynamic window on tables.
Views allow multiple users to see different presentations of the same data. For example, several users may be accessing a table of data about employees. One user may see data about some employees but not others, and another may see some data about all employees but not their salaries. Each of these users is operating on a view that is derived from the real table. Each view appears to be a table and has a name of its own.
An advantage of using views is that you can use them to control access to sensitive data. So, different people can have access to different columns or rows of the data.