Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 22:21:51 GMT

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

Try this....the table shown has 144 rows and you can have the start number change if you wish.

This returns numbers 1 - 144 in the first column. There are many veriations to this.

     SELECT
        sum(case when 1 = 1 then 1 else 1 end)
        over (rows unbounded preceding) +0  newinterval
        from ncr_t.time_of_day_fill

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