from django.db.models import Count from app.models import Email duplicate_emails = Email.objects.values('email').annotate(email_count=Count('email')).filter(email_count__gt=1)