Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2007 @ 10:06:50 GMT


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


Subj:   Re: Removing duplicates from table
 
From:   Curley, David

To follow on what Frank said, "first" doesn't mean anything in RDBMS, not just parallel systems.

If you're doing it in one shot, decide what makes something "first" and qualify on row_number() over (partition by UPI order by "first criteria") = 1.

If you'll be loading more than once or from more than one source table, you'll need to do that and where not exists (select 0 from target_table where target.upi = source.upi).


Dave



     
  <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: 15 Jun 2023