/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

3 votes126 views2 answers
Pandas drop rows with null in specific column
Python
2 votes136 views1 answer
How to add captcha in django forms
Python
13 votes129 views4 answers
Pandas list to df
Python
15 votes156 views3 answers
How to shutdown your computer using python
Python
0 vote139 views1 answer
Datediff in seconds in pandas
Python
-2 votes134 views4 answers
DFS
Python
0 vote165 views1 answer
1. write a program to multiply two numbers using function python
Python
0 vote157 views1 answer
Mutiple condition in dataframe
Python
0 vote179 views2 answers
Flask rest api upload image
Python
11 votes141 views2 answers
Python all permutations of a string
Python