How to perform STD Query in Django?

Question

How should I perform STD operation when I'm working with Django?

SELECT STD(total_cost)              
FROM purchase;

tnx

styling, in general the question was already clear – David Jan 14 '19 at 21:55 — David, Jan 14 '19 at 21:55

score 5 · Answer 1 · answered Jan 14 '19 at 16:02

If you are looking for the Standard Deviation the following should give you what you want:

from django.db.models.aggregates import StdDev

print(Purchase.objects.all().aggregate(StdDev('total_cost')))

See the Django documentation for more information on how aggregation works.

1 Answers1