How to add counter column dyanmically

[Kingkumar]

Hi,
I need to query a table and do some calculations on it and then display the data in ascending order based on a particular column (this part is easy and i got how to do it) now the problem i am facing is that i need to display the data in descding order along with an additional column called "ranking" which would display basically the row number in asceding order
eg.
data ranking
12 1
10 2
etc.
I dont know how to do that dynamically in the query.
thanks.
-Kingreen

 

[JamesLean]

FAQ:

How Do I Get a Row Number On Each Row of a Query Result Set?
faq183-3021

--James

 

[Kingkumar]

Thanks.
I think i didnt put the proper query to search in faq's