Archives of the TeradataForum

Message Posted: Wed, 12 Apr 2006 @ 11:47:21 GMT

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

          > INS DB.Test SEL
          > Name,ProductNumber,csum(1,1) as RowNumber
          > FROM ABC.Atable

Believe it or not but there is a function called ROW_NUMBER. I don't remember now in which release exactly it was introduced but you should be able to find all the details in the Forum's library:

www.teradataforum.com/ncr_pdf.htm , Functions and Operators.

Regards,

Victor

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