本文介绍了一种使用SQL查询来找出并处理表中重复记录的方法。通过子查询与聚合函数结合的方式，有效地筛选出重复的数据，并进一步排除了这些重复项中的非最小ROWID记录。
select whir$3136_f3914,whir$3136_f3916,whir$3136_lx,whir$3136_f3915
from whir$3136 a
where (a.whir$3136_f3916,
a.whir$3136_f3914,
a.whir$3136_f3915,
a.whir$3136_lx) in (select whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
from whir$3136
group by whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
having count(*) > 1)
and rowid not in (select min(rowid)
from whir$3136
group by whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
having count(*) > 1)
and whir$3136_date = '2011-12-27'
from whir$3136 a
where (a.whir$3136_f3916,
a.whir$3136_f3914,
a.whir$3136_f3915,
a.whir$3136_lx) in (select whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
from whir$3136
group by whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
having count(*) > 1)
and rowid not in (select min(rowid)
from whir$3136
group by whir$3136_f3916,
whir$3136_f3914,
whir$3136_f3915,
whir$3136_lx
having count(*) > 1)
and whir$3136_date = '2011-12-27'
扫一扫
1548
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
