oracle去重

標籤：

oracle去重

create table tmp_table3as (SELECT seqno                   FROM (SELECT t.seqno,ROWID,                                ROW_NUMBER() OVER(PARTITION BY title, uin ORDER BY createtime) DUP                           FROM calendar_info t                          where isdelflag = 0                            and specialtype = 1                            --and uin = ‘30647‘                            and comefrom = 12)                  WHERE DUP > 1);--刪除邀請表delete calendar_invite_info where calseqno in (select seqno from tmp_table3);--更新變更表update CALENDAR_SYNC_UPDATE   set token       = calendar_sync_update_token.nextVal,       action_type = 2,       updateTime  = sysdate WHERE calseqno IN (select seqno from tmp_table3);--刪除活動表delete calendar_info where seqno in (select seqno from tmp_table3);

 

oracle去重