QuerySet which returns an object with the maximum field value?

Question

Django

How to write a query to get an object with the maximum value of some field?

Answer 1

max_object = SomeModel.objects.order_by('some_field').last()

or

max_object = (SomeModel.objects
                       .annotate(max_some=Max('some_field'))
                       .filter(some_field=F('max_some'))
                       .first())

Answer 2

https://docs.djangoproject.com/en/dev/topics/db/ag...

>>> from django.db.models import Avg, Max, Min
>>> Book.objects.aggregate(Avg('price'), Max('price'), Min('price'))
{'price__avg': 34.35, 'price__max': Decimal('81.20'), 'price__min': Decimal('12.99')}