[原创]删除重复记录的另一种方法
摘要：
while exists (select count(*) from tablea group by col1 having count(*)>1 )begindelete top (1) from tablea where col1 in(select col1 from tableagroup by col1 having count(*)>1)end 阅读全文
posted @ 2009-11-10 08:51 highmayor 阅读(155) 评论(1) 推荐(0) 编辑
