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

2 votes393 views2 answers
How to get only first record in django
Python Django
0 vote416 views1 answer
Difference between __gte and __lte in Django
Python Django
3 votes297 views2 answers
Django favicon
Python Django
1 vote393 views1 answer
Django set default value for model not form
Python Django
0 vote387 views1 answer
Staff user is not restricting permission in django
Python Django
17 votes395 views2 answers
Install django using pip
Python Django
0 vote380 views2 answers
Generate-thumbnails-in-django-with-pil
Python Django
0 vote414 views1 answer
How to get the current url path in django template
Python Django
2 votes447 views1 answer
Django template tag to display current year
Python Django
0 vote373 views1 answer
Django serializer,
Python Django