/Python/Django model query add annotation field to show duplicate count

Django model query add annotation field to show duplicate count

from django.db.models import OuterRef, Subquery, Count, Min

subquery = Product.objects.filter(bc_sku=OuterRef('bc_sku')).values('bc_sku')
                          .annotate(dup_count=Count('*'), min_price=Min('product_price'))
Product.objects.filter(product_type='good')
               .annotate(dup_count=Subquery(subquery.values('dup_count')), 
                         min_price=Subquery(subquery.values('min_price')))

Similar codes

24 votes137 views5 answers
Python sort descending
Python
0 vote124 views1 answer
How to read a data file in python and build a list of files
Python
32 votes167 views5 answers
Matplotlib install
Python
0 vote115 views1 answer
Stack in python using linked list
Python
0 vote136 views1 answer
Scatter density plot seaborn
Python
0 vote143 views1 answer
How to use tensorboard
Python
2 votes124 views1 answer
Python for loop with increment
Python
0 vote125 views1 answer
Python compine multiple lists
Python
0 vote168 views1 answer
Install matplotlib.pyplot mac python 3
Python
1 vote123 views1 answer
Python rolling mean
Python