如何在django中获取所有重复的记录？

from django.db.models import Count
from django.db.models.functions import Lower

duplicates = YourModel.objects.values('field_name')
                            .annotate(count=Count('field_name'))
                            .filter(count__gt=1)
                            .order_by(Lower('field_name'))

for duplicate in duplicates:
    duplicate_records = YourModel.objects.filter(field_name=duplicate['field_name'])
    # 处理重复的记录，比如打印或者删除
    for record in duplicate_records:
        print(record)