select a.id,a.name,a.tel
from db a,db b
where a.name=b.name and a.tel=b.tel;
from db a,db b
where a.name=b.name and a.tel=b.tel;
解决方案 »
- 9i数据库临时表空间一直膨胀不会自动收缩要怎么处理?
- 请问oracle的DEFAULT_MAINTENANCE_PLAN是干什么用的?
- 关于ORA-08177的问题
- 触发器的问题,谢谢
- oracle中函数调用问题,在线等!!!
- 高分求救,oracle客户端如何远程(即不在同一局域网)访问oracle数据库服务器啊
- 我安装oracle 9i的时候提示系统找不到IP地址
- 大家给点意见,数据库是两层物理结构好,还是两层虚拟的好?
- 菜鸟问题:关于rowid和rownum
- 哪边可以下到oracle high-performance sql tuning这本书的原版?
- 数据库之间导数据的问题(有难度问题)
- 如何取得一个表空间下的所有表名?
Select ID,Name,Tel from table1
Where Name+Tel In(
Select Name+Tel From table1
group by Name+Tel
having count(Name+Tel)>1)
from table a,table b
where a.name=b.name and a.tel=b.tel;
http://community.csdn.net/Expert/topic/3140/3140416.xml?temp=.6964075
的是对的select a.id,a.name,a.tel
from db a,db b *这里说,把这张表复制成为两张, 然后做查询*
where a.name=b.name and a.tel=b.tel;关键就是那个重命名的复制.
from db a,db b
where a.name = b.name and a.tel = b.tel and a.rowid !=b.rowid
但是在2个表里面怎么选择呢就是这样table1:ID NAME TEL
-------------------------------
1 aa 123
2 bb 124
3 cc 332
4 aa 123table2:
TABLE2ID ID NAME TEL
-------------------------------
1 1 aa 123
2 2 bb 124
3 3 dc 332
4 4 aa 123现在想要选择出来table2和table1中
table1.NAME=table2.NAME and table1.TEL = table2.TEL就是上边问题分成了2个表了, 请问怎么样来写SQL,谢谢
不是很清楚么?
------------------------------------------------------------------------------
三张表,TA
------------------------------------------
TA_ID TA_NAME
------------------------------------------
0001 TA1
0002 TA2
0003 TA3
------------------------------------------TB
------------------------------------------
TB_ID TB_NAME
------------------------------------------
001 TB1
002 TB2
------------------------------------------TATB
------------------------------------------
TA_ID TB_ID
------------------------------------------
0001 001
0001 002
0002 001--------------------------------------------------------------------
--------------------------------------------------------------------
用三张表做关连,希望得出
--------------------------------------------
TA_ID TA_NAME TB_NAME_STR
--------------------------------------------
0001 TA1 TB1,TB2
0002 TA2 TB2
0003 TA3
-------------------------------------------------
OPEN curSCPL02020 FOR
select
*
from
csv_up_wk
where
DAIGAKU_CODE = pDaigakuCd
AND
ZYUSIN_NO = pZYUSIN_NO
AND
NAMAE_KANJI || KEITAI_BANGO
in
(
Select
NAMAE_KANJI || KEITAI_BANGO
From
csv_up_wk
Where
DAIGAKU_CODE = pDaigakuCd
AND
ZYUSIN_NO = pZYUSIN_NO
group by
NAMAE_KANJI || KEITAI_BANGO
having count(
NAMAE_KANJI || KEITAI_BANGO
) > 1
);第二个问题:
OPEN curSCPL02020 FOR
select
*
from
csv_up_wk a ,cust_mst b
where
a.NAMAE_KANJI || a.KEITAI_BANGO
in
(
Select
NAMAE_KANJI || KEITAI_BANGO
From
cust_mst
Where
DAIGAKU_CODE = pDaigakuCd
group by
NAMAE_KANJI || KEITAI_BANGO
)
AND
a.DAIGAKU_CODE = pDaigakuCd
AND
a.ZYUSIN_NO = pZYUSIN_NO
AND
a.DAIGAKU_CODE = b.DAIGAKU_CODE
AND
a.NAMAE_KANJI || a.KEITAI_BANGO =
b.NAMAE_KANJI || b.KEITAI_BANGO;