Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 05 May 2004 @ 20:08:57 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Deleting Duplicates with a single DELETE statement
From:   Maxwell, Donald

The use of RowID has been disabled in V2R5 going forward. V2R5.0 offers a GDO flag which can be set to enable RowID, but this flag is not enabled by default. V2R5.1 does not offer this backwards compatibility flag, ie. no use of RowID allowed.

Without using RowID, one way to delete complete row duplicates in a multiset table is to insert-select into a new table, picking a winning row amongst duplicates using a RANK or CSUM function. Alternatively, you could insert-select into a set table (thereby eliminating duplicates). In either case, you would have to then delete your multiset table, and insert-select from your "non-duplicate" table back into your multiset table.

Donald Maxwell

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019