Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2007 @ 20:11:18 GMT

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

Shubhangi,

RANK/OVER can have ties. If you want to be sure of only loading one row, use ROW_NUMBER/OVER.

Thanks,

Bob Diehl

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