Welcome to oracle_awen's archive blog
DELETE FROM baseinfo_goods_packag_factor
      WHERE ROWID IN
               (SELECT a.ROWID
                  FROM (SELECT ch_code,
                               show_code,
                               base_num,
                               flag,
                               hp_id,
                               ROWID
                          FROM baseinfo_goods_packag_factor) a,
                       (SELECT ch_code,
                               show_code,
                               base_num,
                               flag,
                               hp_id,
                               ROWID
                          FROM baseinfo_goods_packag_factor) b
                 WHERE     a.ch_code = b.ch_code
                       AND a.show_code = b.show_code
                       AND a.base_num = b.base_num
                       AND a.flag = b.flag
                       AND a.hp_id = b.hp_id
                       AND a.ROWID <> b.ROWID)
1 条评论
# 1: oracel said:
July 27, 2012, 3:46 pm
建个PK
添加评论

昵称 *

E-mail (防止垃圾信息,此栏留空)