通过ROWID删除重复行

[code]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)[/code]