Archives of the TeradataForum

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

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

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