存在如下的視圖:
create view emp_v as select * from employees where emp_no >10005;
如何擷取emp_v和employees有相同的資料?
CREATE TABLE
employees
(
emp_no
int(11) NOT NULL,
birth_date
date NOT NULL,
first_name
varchar(14) NOT NULL,
last_name
varchar(16) NOT NULL,
gender
char(1) NOT NULL,
hire_date
date NOT NULL,
PRIMARY KEY (
emp_no
));
--intersect求交集
select * from employees intersect select * from emp_v;