delete from (select d_book_date,i_rid,i_from_tsid,i_to_tsid,i_b_uid, row_number() over(partition by d_book_date,i_rid,i_from_tsid,i_to_tsid,i_b_uid) as row_seq from mr_book_data) t where t.row_seq>1;
DB2 删除重复记录
最新推荐文章于 2021-02-06 17:02:13 发布
delete from (select d_book_date,i_rid,i_from_tsid,i_to_tsid,i_b_uid, row_number() over(partition by d_book_date,i_rid,i_from_tsid,i_to_tsid,i_b_uid) as row_seq from mr_book_data) t where t.row_seq>1;