Thread: Ranking Results

Hi

 

I have a query that is grouping by 3 fields and returning a sum of another field. I would also like a further field to be returned that shows a ranking for the records based on the sum field. This should really only be a numbering of the rows returned, since I will do the ordering in an ORDER BY clause

 

A Simplistic example:

 

SELECT f1, f2, f3, sum(f4)

FROM TableA

GROUP BY f1, f2, f3

ORDER BY f2,f1,f3

 

Now I would like to add another field that simply return 1,2,3,4,5,etc.. for each row that is returned.

 

Can this be done?

 

Thanks

Craig