Archives of the TeradataForum

Message Posted: Fri, 03 Oct 2008 @ 13:07:52 GMT

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

Rank deals with ties in the data and that is why you are seeing gaps in the numbers. Use the Row_Number() function instead.

E. John Aldrin
Teradata Corporation

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