Best Answer · By JanBask Business Analyst Expert
Kaushik Chandra JanBask Expert
Answered on Jun 11, 2019
A view is a virtual table and it is a named set of SQL statements that can be later referenced and utilized as a table.
Syntax,
CREATE VIEW view_name AS
SELECT column1, column2, ….
FROM table_name
WHERE condition;
Example,
CREATE VIEW [INDIA Customers] AS
SELECT CustomerName, ContactName
FROM Customers
WHERE Country = "INDIA";
Was this helpful?
