Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 14:57:05 GMT


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


Subj:   How to delete selectively
 
From:   Imran.Khan

Hi,

like we use select statement in following query:

     select * from table_name
     order by 1 sample 50;

can we selectively delete first n rows by using order by clause and sample key word...

the following query does not work:

     delete from table_name
     order by 1 sample 50;

thanks in advance

Imran Khan



     
  <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: 27 Dec 2016