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 vote3 views1 answer
Django iterating through objects
Python Django
5 votes60 views4 answers
Import user in django
Python Django
0 vote67 views1 answer
How to redirect in django rest framework
Python Django
4 votes51 views1 answer
Django objects.create()
Python Django
0 vote63 views1 answer
Initial TypedMultipleChoiceField django
Python Django
0 vote60 views5 answers
Django-tool-bar
Python Django
1 vote61 views2 answers
Management command in django
Python Django
1 vote53 views1 answer
Ls.ProgrammingError: permission denied for table django_migrations
Python Django
1 vote60 views1 answer
Django filter by date range
Python Django
0 vote57 views1 answer
Django add to database
Python Django