Archives of the TeradataForum

Message Posted: Tue, 23 Feb 2010 @ 15:48:48 GMT

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

You can use row_number() and then order on whatever columns you want to force the order.

If it is arbitrary the difference between the rank 2 and 3, then no need to worry.

Thanks,

Eric W. Barner

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