|
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
|
