Archives of the TeradataForum

Message Posted: Thu, 16 Apr 2009 @ 12:22:40 GMT

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

Hi,

I hope you are trying to insert the data from multiset to a set table with UPI.

To find the records which doesnot have the Uniqueness on PI Column run the below query.

     Select a.*, Row_Number() over(Partition by PI Columns Order by PI
     Columns) as Rnum from tablename a
     Qualify rnum>2;

Regards

Meher

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