A view can be used to:
A view can be used to:
A view is a virtual table that result from a pre-defined query on one or more tables. It does not store data physically. One of the main purposes of a view is to limit access to specific rows or columns of data in a table, thereby providing a layer of security by showing only the necessary data to the users while hiding the rest.
you can create a view that is a subset of a table. that way users can access that subset without needing full access to the table
View is a virtual table as the fields in the view do not have physical existence and are not stored into the database.