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.
Leave a Reply