Archives of the TeradataForum

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

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

<-- 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>>