[Django]-Is it possible to delete last n records of a django model in one/minimum database query?

4👍

You can use the primary keys in the queryset to filter with pk__in=…:

Task.objects.filter(
    pk__in=Task.objects.filter(type='Active').order_by('-id').values('pk')[:10]
).delete() 

Leave a comment