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