Archives of the TeradataForum

Message Posted: Wed, 12 Apr 2006 @ 17:25:55 GMT

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

Hi Chaim,

You could use the RANK function but it's almost the same idea as CSUM.

     SELECT
        RANK(ACC.ACC_NO ASC)
       ,ACC.ACC_NO
     FROM
        ACCOUNT   ACC;

Fachtna O'Donovan
Data Warehouse Software Engineer
AIB Bank
Ireland

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