SQL Row Count

[ADB1]

Is ther a function in Teradata SQL to bring back a column which allocates a consecutive number to rows returned ie. 1,2,3,4,5 and so on.

Thanks,

Adam.

 

[BillDHS]

Use the CSUM function, for example:

Select Name, CSUM(1,1)
From Table1
Order By 1;

You may need to play with the order by and the second 1 (sort column ) in the CSUM function to get the rows ordered the way you want.

The RANK function also works:

Select Name, RANK(Name)
From Table1
Oder By 1;

The problem with RANK is the ranking column MUST BE unique for the values to be unique, for exampl if two people have the nane Smith, they both get the same RANK.