Archives of the TeradataForum

Message Posted: Mon, 29 Oct 2007 @ 20:44:21 GMT

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

CSUM has been left for backward compatibility.

I would use ROW_NUMBER and MAX constructs.

MAX is needed for you to find the max value in the unique key.

Thanks,

Vinay Bagare

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