Lesson 24 — Views

Views: save a query under a name

A view is a saved SELECT that behaves like a read-only table. You write the complex query once — joins, grouping — and afterwards everyone can simply SELECT from the view. The data is not copied: the view runs its query each time, so it is always up to date.

CREATE VIEW big_orders AS SELECT * FROM orders WHERE total > 100
SELECT * FROM big_orders

Why it matters: views give analysts and apps a simple, stable "table" while the messy details stay in one place.