Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2005 @ 20:42:50 GMT

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

RANK   () OVER ([PARTITION BY column(s)] ORDER BY column(s) [ASC | DESC])

This will do exactly what you are looking for I believe. It resets the rank back to 1 any time the column(s) in the PARTITION BY portion changes.

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