Django queryset group by

Django group by

# If you mean to do aggregation you can use the aggregation features of the ORM:
from django.db.models import Count
Members.objects.values('designation').annotate(dcount=Count('designation'))

# This results in a query similar to:
SELECT designation, COUNT(designation) AS dcount
FROM members GROUP BY designation

#and the output would be of the form
[{'designation': 'Salesman', 'dcount': 2}, 
 {'designation': 'Manager', 'dcount': 2}]

Source: stackoverflow.com

Similar codes

0 vote181 views1 answer
Python django if key exists
Python Django
30 votes393 views6 answers
How to create a superuser in django
Python Django
-1 vote234 views1 answer
Cannot import name 'httpresponse' from 'django.http'
Python Django
3 votes225 views1 answer
Django admin prefetch_related
Python Django
0 vote221 views2 answers
Django APIView Pagination
Python Django
0 vote233 views1 answer
How to send file in django response
Python Django
0 vote252 views6 answers
Django wht post save signal not firing
Python Django
0 vote242 views1 answer
How to populate an image to template in django from views
Python Django
0 vote237 views1 answer
Django blog new post
Python Django
4 votes236 views3 answers
No such table: django_session
Python Django