select t1.id,t1.name from t1 Intersect select t2.id,t2.name from t2;select t1.id,t1.name from t1 Minus select t2.id,t2.name from t2;
解决方案 »
- 我要查询oracle表的字段名sql语句怎么写
- 关于两张表之间查询
- 请教如何在sco unix 5.0.5下将oracle 7.3.4字符集修改为 WE8ISO8859P9
- oracle怎么根据表建立数据库
- 这样两个表该怎么样进行关联
- 关掉Oracle8i的managerServer服务之后 无法重起
- 查询数据库结果集太大,而导致内存溢出
- ???Long Raw 域内字符串的搜索问题???
- 在线高分急等!!
- 高分求解有关dbms_session.unique_session_id的问题,急急急!!!!!!
- Oracle怎么书写sql server中top 3之类的sql(就是成绩前三名的学生之类需求)
- 在A表的触发器中不能再对A表进行操作,为什么? 我也实在没办法了!!!
---------- ----------
3 4
5 6
6 7
1 2
2 3
SELECT yh
FROM aazz
MINUS
SELECT yh2 FROM aazz
YH
----------
1
5
SELECT yh
FROM aazz
intersect
SELECT yh2 FROM aazz
YH
----------
2
3
6
create table test2(serialno number,clientid number,thisbargain number,usenum number);
insert into test(serialno,clientid,thisbargain,usenum)
select 1,1,10,1 from dual union all select 2,1,10,2 from dual
union all select 3,1,10,4 from dual union all select 4,2,10,1 from dual
union all select 5,2,10,4 from dual union all select 6,2,10,5 from dual;
insert into test2(serialno,clientid,thisbargain,usenum)
select 1,1,10,1 from dual union all select 2,1,10,2 from dual
union all select 3,1,10,4 from dual union all select 4,2,10,1 from dual
union all select 7,2,10,4 from dual union all select 8,2,10,5 from dual;select * from test intersect select * from test2;select * from test minus select * from test2;drop table test;
drop table test2;