Ranking Results

Поиск
Список
Период
Сортировка
От Craig
Тема Ranking Results
Дата
Msg-id 000d01c5b89e$cf1858b0$0300a8c0@amd64
обсуждение исходный текст
Ответы Re: Ranking Results
Список pgsql-general
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

В списке pgsql-general по дате отправления: