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

24 votes509 views6 answers
Static files in django
Python Django
0 vote377 views1 answer
How to log errors while debug is false in django
Python Django
1 vote344 views1 answer
Error popup in django not visible
Python Django
0 vote340 views1 answer
Print choicefield data from database in django
Python Django
0 vote350 views1 answer
Redis in django channels
Python Django
0 vote378 views1 answer
Travis deployment script for django applications to heroku
Python Django
9 votes320 views2 answers
Django delete instance
Python Django
0 vote335 views1 answer
Django change foreign key
Python Django
0 vote344 views1 answer
Sending email in django
Python Django
2 votes300 views2 answers
Django and operator
Python Django