Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 16:41:07 GMT

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

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

Something like

     Delete tblname
     Where tblname.keycolumns in
     (select tblname.keycolumns from tblname group by x,x having count(*) > 1)

Thanks,

Bob Diehl

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