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

1 vote270 views1 answer
Django class based views ListView
Python Django
0 vote218 views1 answer
Merge two query sets django
Python Django
1 vote252 views1 answer
Query with condition django
Python Django
2 votes268 views1 answer
Truncate templat tag django
Python Django
1 vote262 views3 answers
Making ckeditor django responsive
Python Django
2 votes215 views1 answer
Django register models
Python Django
3 votes243 views1 answer
Csrf token exempt django
Python Django
14 votes247 views6 answers
Install django
Python Django
0 vote223 views1 answer
How to create decorator function in django
Python Django
19 votes244 views6 answers
Pip install django
Python Django