Example
A view can filter some rows from the base table or project only some columns from it:
CREATE VIEW new_employees_details AS
SELECT E.id, Fname, Salary, Hire_date
FROM Employees E
WHERE hire_date > date '2015-01-01';
If you select form the view:
select * from new_employees_details
| Id | FName | Salary | Hire_date |
|---|---|---|---|
| 4 | Johnathon | 500 | 24-07-2016 |
