删除一张表中相同的数据
delete from ho_old_nn_buy_price
where rowid in (select max(rowid) from ho_old_nn_buy_price
group by art_no
having count(art_no)>1)
删除一张表中相同的数据
delete from ho_old_nn_buy_price
where rowid in (select max(rowid) from ho_old_nn_buy_price
group by art_no
having count(art_no)>1)