Archives of the TeradataForum

Message Posted: Thu, 30 Jun 2005 @ 05:13:52 GMT

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

Glenn David McCall wrote:

Or simply use a subquery, but this results in a 3706 "sample not allowed in subqueries".

But it'a allowed within a derived table :-)

     Delete from some_table
     Where (col1, col2, col3) in
       (select *
        from
          (Select col1, col2, col3
            From some_table
            Sample 50) dt
        );

Dieter

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