You need to do some little reading about Django aggregation
https://docs.djangoproject.com/en/2.2/topics/db/aggregation/#topics-db-aggregation
Example
from django.db.models import Max, Count, Sum
Publisher.objects.values('name').annotate(*dcount*=Count('name'))
As seen above you can apply similar method to get Max, Sum and others
On Mon, Dec 2, 2019 at 2:43 PM xiaopeng luo <xpluo....@gmail.com> wrote:
> I am new to django ORM, I want query something like this:
>
> input:
> AAA female 1
> AAA female 2
> BBB male 1
> BBB male 3
> AAA male 2
>
>
>
> output
> AAA female 3
> AAA male 2
> BBB male 4
>
>
> Sorry, my english is not good. Thanks for everyone help me.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/a297dc1f-6821-4bba-b04c-e8ce271b5a8d%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/a297dc1f-6821-4bba-b04c-e8ce271b5a8d%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAHyB84qihZj5mVNnL2C-BmE%3D2RAdsvVoOYfrfiH04BaPQ%3D5E2Q%40mail.gmail.com.
