摘要：
1.删除重复项, 只保留第一条deletetable t1where t1.ID not in ( select min(t2.ID) fromtable t2 group by t2.ColName)2.查找重复记录select t1.ID, count(*) from table group by t1.ID having count(*) > 1 order by count(*) d... 阅读全文
posted @ 2008-10-31 19:38
子逸
阅读(1717)
评论(0)
推荐(1)
浙公网安备 33010602011771号