/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

2 votes310 views3 answers
Select rows in python
Python
0 vote268 views1 answer
Print("python is good")
Python
0 vote247 views1 answer
Change python version 3 to 2.7
Python
0 vote280 views1 answer
Use gpu for python code in vscode
Python
2 votes315 views2 answers
Python "for in" loop to print the last item in the list
Python
16 votes287 views3 answers
How to code music in python
Python
4 votes293 views4 answers
Filter django or
Python
3 votes264 views1 answer
Parentheses balancer python
Python
1 vote284 views1 answer
The python libraries to master for machine learning
Python
0 vote289 views1 answer
Python remove suffix
Python