Archives of the TeradataForum

Message Posted: Wed, 12 Apr 2006 @ 10:33:52 GMT

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

Hello there,

Does anyone have an alternative way of creating row numbers using Teradata SQL other than using csum(1,1) as below?

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

Cheers,

Chaim

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