How to sum three columns using django ORM

Question

I'd like to execute such query using djagno models:

SELECT id, ( first+second+third ) FROM testTable

Without grouping. Was trying to find the solution using google but unsuccessfully.

Thanks in advance,

olieidel · Accepted Answer · 2017-10-01 16:40:41Z

8

Use F() and annotate():

from django.db.models import F

# the sum of the three columns `first`, `second` and `third` will be
# accessible as `.my_sum`
results = my_model.objects.annotate(
                         my_sum=F('first') + F('second') + F('third'),
                       )

answered Oct 1, 2017 at 16:40

olieidel

1,57510 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sum three columns using django ORM

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related