Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 30 Jun 2005 @ 20:12:31 GMT

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

Subj:   Re: How to delete selectively
From:   Anomy Anom

<-- Anonymously Posted: Thursday, June 30, 2005 09:52 -->

Hello ,

The delete statement will result in an error - since 'sample' and 'order by' cannot be used in a delete statemtent.

You can try something like this :

     del from table_name a
     where n < (sel count(*)  from table_name b
                where a.column < b.column)

Hope it works for you.

  <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