Archives of the TeradataForum

Message Posted: Thu, 23 Sep 2004 @ 19:21:50 GMT

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

Shrinivas:

If you are on V2R5 the function is called ROW_NUMBER. If you are not on V2R5, then you can use CSUM(1,<sort-column>).

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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