Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 16:58:31 GMT


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

Do a delete with a subselect with a having count > 1?

Bob, the statement deletes all duplicates. The OP wants to keep one row for each group of duplicates.

Regards,

Victor


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

Archives

2005 Indexes

Last Modified: 15 Jun 2023