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]
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]