Creating and Using Views

A view is a virtual table based on a SQL query. It helps simplify complex queries and enhance security.

CREATE VIEW high_salary AS
SELECT name, salary FROM employees
WHERE salary > 100000;

SELECT * FROM high_salary;

Views are useful for reusing logic and hiding sensitive columns from users.