What is a view in SQL? How to create one

Posted by

To view Verified answers click on the button below.

Ans: A view is a virtual table based on the result-set of an SQL statement. We can create
using create view syntax.
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition