rsdlnew
ID danhao1 danhao2
1 A b
2 A b
3 A b
4 b D当danhao1和danhao2重复,就判断为重复的记录SELECT * FROM rsdl WHERE danhao1 IN (select danhao1 from rsdl group by danhao1 having count(*)>1) and danhao2 in (select danhao2 from rsdl group by danhao2 having count(*)>1) 我这样写好像把所有的数据都列出来了
ID danhao1 danhao2
1 A b
2 A b
3 A b
4 b D当danhao1和danhao2重复,就判断为重复的记录SELECT * FROM rsdl WHERE danhao1 IN (select danhao1 from rsdl group by danhao1 having count(*)>1) and danhao2 in (select danhao2 from rsdl group by danhao2 having count(*)>1) 我这样写好像把所有的数据都列出来了
insert @a select 1, 'A' ,'b'
union all
select 2 ,'A', 'b'
union all
select 3, 'A' ,'b'
union all
select 4, 'b', 'D'select danhao1,danhao2 from @a group by danhao1,danhao2 having count(*)>1
rsdlnew 表中
我不知道danhao1和danhao2 字段里的数据是什么
列出重复的。。
ID danhao1 danhao2
1 张 001
2 张 002
3 张 003
4 张 001当结果是
danhao1 danhao2
张 001就判断为重复的记录当然我不知道 danhao1和danhao2里的数据是什么
from tab
group by danhao1 ,danhao2
having count(*) > 1