Archives of the TeradataForum

Message Posted: Wed, 23 Jun 2004 @ 14:08:02 GMT

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

Siddhartha:

In Teradata the function you want is called ROW_NUMBER and is written as:

     row_number() over (order by )

Hope this helps,

Michael Larkins
Certified Teradata Master

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