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
If you're talking about row numbering rather than ranking, you can try a temporary sequence:
