Archives of the TeradataForum

Message Posted: Thu, 19 Aug 2004 @ 21:12:33 GMT

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

<-- Anonymously Posted: Thursday, August 19, 2004 17:11 -->

Thanks for your responses.

But I wanted to clarify the query in more detail.

I want to delete only 1 row from the result of the select subquery.

The sub query will result in (A,B,C1,1,2,3) and (A,B,C2,1,2,3)

And the delete part will delete both the rows.

I want to delete only one row (any 1 one the resultant rows).

Thanks

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