Django select only rows with duplicate field values

by

Try:

from django.db.models import Count
Literal.objects.values('name')
               .annotate(Count('id')) 
               .order_by()
               .filter(id__count__gt=1)

This is as close as you can get with Django. The problem is that this will return a ValuesQuerySet with only name and count. However, you can then use this to construct a regular QuerySet by feeding it back into another query:

dupes = Literal.objects.values('name')
                       .annotate(Count('id'))
                       .order_by()
                       .filter(id__count__gt=1)
Literal.objects.filter(name__in=[item['name'] for item in dupes])

More Related Contents:

  1. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  2. How can I see the raw SQL queries Django is running?
  3. LEFT JOIN Django ORM
  4. How to perform OR condition in django queryset?
  5. How to select a record and update it, with a single queryset in Django?
  6. Django in / not in query
  7. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  8. Using django how can I combine two queries from separate models into one query?
  9. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  10. Escaping keyword-like column names in Postgres
  11. SQL left join vs multiple tables on FROM line?
  12. TSQL Pivot without aggregate function
  13. Delete duplicate rows (don’t delete all duplicate)
  14. Why are there gaps in my IDENTITY column values?
  15. What is the reason not to use select *?
  16. GROUP BY + CASE statement
  17. Return a value if no record is found
  18. How do I return rows with a specific value first?
  19. How to count occurrences of a column value efficiently in SQL?
  20. Perform this hours of operation query in PostgreSQL
  21. How do I pass a list as a parameter in a stored procedure?
  22. Sorting string column containing numbers in SQL?
  23. Store multiple bit values in a single table column
  24. Grant SELECT permission on a view, but not on underlying objects
  25. Group All Related Records in Many to Many Relationship, SQL graph connected components
  26. How do I call an Oracle stored procedure from an Excel VBA script?
  27. Linq to SQL: How do I stop the auto generated object name from being renamed?
  28. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  29. Previous Monday & previous Sunday’s date based on today’s date
  30. SQL add filter only if a variable is not null

Leave a Comment