CREATE VIEW

Save a query as a view.

With CREATE VIEW you name a query. It can later be used like a table.

CREATE VIEW expensive_products AS
SELECT name, price FROM products WHERE price > 100;

VIEW for expensive products.

The view expensive_products is created. name, price is selected from products. WHERE keeps only the rows where price > 100 holds.

CREATE VIEW — details

The VIEW name is used like a table name. You write SELECT * FROM expensive_products.

As long as the view definition stays the same, reports using it don't change; you only update the underlying query in one place.

Create the expensive_products VIEW for products over 100.

Show example solution

CREATE VIEW expensive_products AS
SELECT name, price FROM products WHERE price > 100;

Add AS

CREATE VIEW expensive_products ____
SELECT name, price FROM products WHERE price > 100;

Show answer

CREATE VIEW expensive_products AS
SELECT name, price FROM products WHERE price > 100;