DB2 删除重复记录

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;