Archives of the TeradataForum

Message Posted: Wed, 10 Nov 2010 @ 07:48:04 GMT

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

Lakhwant,

I do agree with YASh and below is differ way to get the same result.

     Select
     rank(field1 asc,field2 asc,field3 asc,field4 desc)
             ,Field1
             ,Field2
             ,Field3
             ,Field4
     from tablea

Regards,

Vivek Wadhwa / Capgemini
Financial Services Strategic Business Unit

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