Skip
Arish's avatar

288. CREATE VIEW

VIEWS

Virtual table from a query.

sql
1CREATE VIEW high_scorers AS
2SELECT name, marks FROM students WHERE marks > 85;

Use like a table:

sql
1SELECT * FROM high_scorers;