一、利用临时表
select distinct * into #test from casepicture
select * from #test
select * into casepicture from #test
二、利用分组
SELECT caseid
FROM cases
GROUP BY caseid
HAVING COUNT(caseid) > 1
可以查看那些列重复了
一、利用临时表
select distinct * into #test from casepicture
select * from #test
select * into casepicture from #test
二、利用分组
SELECT caseid
FROM cases
GROUP BY caseid
HAVING COUNT(caseid) > 1
可以查看那些列重复了