Organizational Research By

Surprising Reserch Topic

What is a View?


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]

asked Sep 13, 2013 in Database(DBMS) by rajesh
edited Sep 12, 2013
0 votes
15 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...