how to get count of each distinct value

[Fatih Tiryakioglu]

Hi all,

How can I get distribution of values in a field? For example, I have the scores below:

             (score)

(raw1)        1

(raw2)        1

(raw3)        3

(raw4)        4

(raw5)        4

(raw6)        5

(raw7)        8

(raw8)        8

(raw9)        9

(raw10)    10

I want to have a result like that: {1: 2}, {3: 1}, {4: 2}, {5: 1}, {8: 2}, {9: 1}, {10: 1}. So it is {score: count}.

How can I evaluate this only one db hit?

Thanks all.

--

[Larry Martell]

In SQL:

SELECT score, COUNT(*) FROM foo GROUP BY score; 

In Django:

from django.db.models import Count
q = Foo.objects.values('score').annotate(Count('score'))

for r in q:
    print r, r.score__count

[Fatih Tiryakioglu]

Thank you.

--

22 Kasım 2013 Cuma 18:07:47 UTC+2 tarihinde Larry....@gmail.com yazdı: