View

Applies to: sql

A SQL view is a saved query that behaves like a virtual table.

CREATE VIEW active_users AS
SELECT * FROM users WHERE active = 1;

See also: select, cte