如:有
记录一.GDDM=记录一.GDDM and 记录二.GDXM=记录二.GDXM
这里所指的记录都是在同一表中的
这样的话,岂不是所有记录?
没看明白!?
是不是:记录一.GDDM=记录二.GDDM and 记录一.GDXM=记录二.GDXM
记录一.GDDM=记录一.GDDM and 记录二.GDXM=记录二.GDXM
这里所指的记录都是在同一表中的
这样的话,岂不是所有记录?
没看明白!?
是不是:记录一.GDDM=记录二.GDDM and 记录一.GDXM=记录二.GDXM
select gddm,gdxm,count(*) into #table from Utable group by gddm,gdxm having count(*) > 1
--
select * from #table
好象是证券中的股东代码,股东姓名?
select * from 表 a where exists(select 1 from
(select * from 表 group by GDDM,GDXM having count(*)>1) b where a.GDDM=b.GDDM and a.GDXM=b.GDDM)
from Utable
group by gddm,gdxm
having count(*) > 1
同楼上
(
select gddm , gdxm from yourtable
group by gddm,gdxm having count(*) > 1
)above is oracle syntax , If it's not supported by sqlserver . you can rewrite like
select * from yourtable where gddm+gdxm in
(
select gddm+gdxm from yourtable
group by gddm+gdxm having count(*) > 1
)
'+' means connect 2 string columns , I am not sure what's the function name in sqlserver
group by GDDM,GDXM having count(*)>2) b
where a.gddm=b.gddm and a.GDXM = b.GDXM 查询有重复的记录