SQL简单视图
示例
视图可以过滤基表中的某些行或仅从基表中投影某些列：
CREATE VIEW new_employees_details AS SELECT E.id, Fname, Salary, Hire_date FROM Employees E WHERE hire_date > date '2015-01-01';
如果从视图中选择：
select * from new_employees_details
视图可以过滤基表中的某些行或仅从基表中投影某些列：
CREATE VIEW new_employees_details AS SELECT E.id, Fname, Salary, Hire_date FROM Employees E WHERE hire_date > date '2015-01-01';
如果从视图中选择：
select * from new_employees_details