Django orm get latest for each group

by

If your DB is postgres which supports distinct() on field you can try

Score.objects.order_by('student__username', '-date').distinct('student__username')

More Related Contents:

  1. Django Aggregation: Summation of Multiplication of two fields
  2. How to perform OR condition in django queryset?
  3. What’s the difference between select_related and prefetch_related in Django ORM?
  4. Django filter queryset __in for *every* item in list
  5. How can I filter a Django query with a list of values?
  6. Getting the SQL from a Django QuerySet [duplicate]
  7. How do I do a not equal in Django queryset filtering?
  8. Django Query That Get Most Recent Objects From Different Categories
  9. How to execute a GROUP BY … COUNT or SUM in Django ORM?
  10. How do I get the object if it exists, or None if it does not exist in Django?
  11. Django self-referential foreign key
  12. LEFT JOIN Django ORM
  13. Serializing Foreign Key objects in Django
  14. django – convert a list back to a queryset [duplicate]
  15. Django Blob Model Field
  16. Django values_list vs values
  17. many-to-many in list display django
  18. How to combine multiple querysets in Django?
  19. “_set” in a queryset object in Django
  20. aggregate() vs annotate() in Django
  21. Count() vs len() on a Django QuerySet
  22. Simple Subquery with OuterRef
  23. QuerySet, Object has no attribute id – Django
  24. Django custom annotation function
  25. django filter on the basis of text length
  26. What is the default order of a list returned from a Django filter call?
  27. Django filter JSONField list of dicts
  28. How to annotate Count with a condition in a Django queryset
  29. How to delete a record in Django models?
  30. Can a dictionary be passed to django models on create?

Leave a Comment