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 vote272 views1 answer
Django prepopulated_fields
Python Django
0 vote333 views1 answer
Is_valid method django
Python Django
0 vote316 views1 answer
Get list of all document in django-elasticsearch-dsl
Python Django
0 vote318 views5 answers
Django-tool-bar
Python Django
0 vote334 views1 answer
Django form set min and max value
Python Django
15 votes353 views4 answers
Django python install
Python Django
0 vote296 views1 answer
Django querset group by sum
Python Django
0 vote307 views1 answer
User passes test django
Python Django
6 votes297 views2 answers
How to check if django is installed( in python shell)
Python Django
14 votes315 views6 answers
Installing django on windows
Python Django