View is a virtual table which is created on the basis of the result set returned by the select statement.

CREATE VIEW [MyView] AS SELECT * from pcdsEmployee where LastName = ‘singh’

In order to query the view

SELECT * FROM [MyView]

A view in a database management system (DBMS) is a virtual table that is based on the result of a SELECT query. It presents data from one or more tables in the database in a structured format, similar to a table, but it does not store any data itself. Instead, it dynamically retrieves data from the underlying tables whenever it is queried. Views are useful for simplifying complex queries, providing security by restricting access to certain columns or rows, and abstracting the underlying data structure.