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 vote245 views1 answer
Ssl django nginx
Python Django
0 vote239 views6 answers
Python django
Python Django
0 vote249 views1 answer
What is NoReverseMatch in django?
Python Django
0 vote249 views1 answer
Django trim string whitespace
Python Django
0 vote255 views1 answer
Django date grater
Python Django
0 vote237 views1 answer
Remove last comma forloop django
Python Django
2 votes246 views2 answers
How to check django rest framework version
Python Django
-1 vote290 views1 answer
What is admin.tabularinline django
Python Django
1 vote230 views1 answer
Ls.ProgrammingError: permission denied for table django_migrations
Python Django
2 votes252 views2 answers
Or operator django
Python Django