Django equivalent of count with group by in Python Programming Language?

editAnswer

reportReport

Answer(s) available: 1

Subaahu Sama

, Consultant, Specifications

"

If you are using Django 1.1 beta (trunk):

"
Player.objects.values('player_type').order_by().annotate(Count('player_type'))"
"
    "
  • values('player_type') - for inclusion only player_type field into GROUP BY clause.
  • "
  • order_by() - for exclusion possible default ordering that can cause not needed fields inclusion in SELECT and GROUP BY.
  • "
"

thumb_upUpvote7

smsComment

reportReport