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 vote224 views1 answer
Django data from many to many field in template
Python Django
0 vote241 views1 answer
Substring in a django template?
Python Django
2 votes159 views1 answer
Django.core.exceptions.improperlyconfigured: wsgi application 'backend.wsgi.application' could not be loaded; error importing module.
Python Django
1 vote209 views1 answer
Django populate choice field from database
Python Django
0 vote235 views1 answer
The requested resource was not found on this server. django
Python Django
0 vote212 views1 answer
Access host database django docker
Python Django
0 vote214 views3 answers
Django add user to group
Python Django
0 vote207 views2 answers
Django serializer method field read write
Python Django
0 vote243 views1 answer
Django dumpdata specific app
Python Django
2 votes205 views1 answer
Database default code in settings django
Python Django