Archives of the TeradataForum

Message Posted: Wed, 28 Mar 2012 @ 16:49:34 GMT

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

Hi,

This will gives you duplicates on a table if col1 is unique key

If you have more columns add them in select and group by

     select col1,count(*)
     from table a
     group by col1
     having count(*) >1;

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