[大数据]MySQL与ORACLE交、并、差集

一、MySQL

create table t_1 (id int(5) primary key ) ;

insert into t_1 values(1);

insert into t_1 values(2);

insert into t_1 values(3);

insert into t_1 values(4);

insert into t_1 values(5);

create table s_1 (id int(5) primary key ) ;

insert into s_1 values(1);

insert into s_1 values(2);

insert into s_21values(5);

insert into s_1 values(8);

insert into s_1 values(9);

交集
select * from t_1 as t inner join s_1 as s on s.id = t.id ;

并集
select * from t_1 union select * from s_1 ;

差集
1、t_1与s_1差集
select * from t_1 where id idt in (select * from s_1);
2、s_1与t_1差集
select * from s_1 where id idt in (select * from t_1);

二、ORACLE

create table t_1 (id number(5) primary key ) ;

insert into t_1 values(1);

insert into t_1 values(2);

insert into t_1 values(3);

insert into t_1 values(4);

insert into t_1 values(5);

create table s_1 (id number(5) primary key ) ;

insert into s_1 values(1);

insert into s_1 values(2);

insert into s_1 values(5);

insert into s_1 values(8);

insert into s_1 values(9);

交集
select * from t_1 intersect select * from s_1 ;

并集
select * from t_1 union select * from s_1 ;

差集
1、t_1与s_1差集
select * from t_1 minus select * from s_1 ;
2、s_1与t_1差集
select * from s_1 minus select * from t_1 ;