from < table > group by 1,2,...,n having count (*) > 1;

-dave.clark

Archives of the TeradataForum

Message Posted: Wed, 05 May 2004 @ 18:57:29 GMT


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

Subj:		Re: Deleting Duplicates with a single DELETE statement

From:		Clark, Dave

To find all of the duplicate rows in a particular multiset table use the query below:

    ----------------------------------------------------------

    select < col 1 >, < col 2 >, ... ,


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

Archives

2004 Indexes