What is a view in SQL?

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";