View

A view is a virtual table based on the result of an SQL query that does not store data physically but provides a logical representation of it.

Example SQL View:

sqlCopyEditCREATE VIEW HighSalaryEmployees AS
SELECT name, salary FROM Employees WHERE salary > 50000;

Querying the view:

sqlCopyEditSELECT * FROM HighSalaryEmployees;

Returns only employees with a salary above 50,000.