Archives of the TeradataForum

Message Posted: Tue, 08 Jan 2002 @ 15:15:46 GMT

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

This may not be the exact solution, i think this would help

Sel
Area
,Prod
,csum(1, Area asc) -rank( Area asc )+1
from db.table

Thanks

Sudarsan Thopay

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