从一个表中查找某两个字段重复的记录,把所有重复记录插入到另一表中。
sql代码如下:
  insert into t1 select * from wood where rtrim(reason)+rtrim(CONVERT(char(20), dup_id))  in
(select rtrim(a.reason)+rtrim(CONVERT(char(20), a.dup_id))
from
(select reason, dup_id from wood group by reason, dup_id having count(*)>1) a)

Posted on 2005-07-21 11:40  beck  阅读(197)  评论(0编辑  收藏  举报