Try it Yourself: SQL Views

SQL Views

Language: SQL

CREATE VIEW ActiveCustomers AS
SELECT CustomerID, CustomerName, City
FROM Customers
WHERE Active = 1;

CREATE VIEW ActiveCustomers AS
SELECT CustomerID, CustomerName, City
FROM Customers
WHERE Active = 1;

Output

Click Run to execute this code.