Archives of the TeradataForum

Message Posted: Sat, 27 Oct 2007 @ 14:56:17 GMT

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

Hi Soumya,

it would be helpful, if you could post some data and expected result set (preferably as CREATEs and INSERTs).

It looks like your trying to calculate a kind of DENSE_RANK?

Dieter

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