Archives of the TeradataForum

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

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

Chaim Sender wrote:

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

*Never* use CSUM(1,1), because it will be totally skewed.

Since V2R5 there's a SQL:1999 compliant ROW_NUMBER() OVER (ORDER BY ...)

Dieter

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