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

5 votes302 views2 answers
Get_object_or_404 django
Python Django
0 vote271 views1 answer
Truncatechars django
Python Django
0 vote256 views1 answer
Add many instances to related field manytoamny django]
Python Django
0 vote287 views1 answer
Get ip address in django
Python Django
0 vote310 views1 answer
Add url parameter in anchor django template
Python Django
10 votes279 views2 answers
Django delete object
Python Django
1 vote286 views1 answer
Managin media django
Python Django
-1 vote318 views1 answer
What is admin.tabularinline django
Python Django
0 vote271 views1 answer
Django http response 204
Python Django
2 votes285 views1 answer
Django flush database
Python Django