Sum columns in Sqlite3

Question

I made a Select on Sqlite3 for my QTableWidget, but when it executes it gets this

(E.VALOR_VENDA-E.VALOR_CUSTO) the result in the table is = "3...."

and in pure SQL it is correct = "3.57"

VALOR_VENDA = 5.87
VALOR_CUSTO = 2.3

Does anyone know why? I tried to correct but nothing has changed.

        query = """SELECT E.CODBARRA, E.PRODUTO, 
                          C.CATEGORIA, E.ESTOQUE, 
                          E.ESTOQUE_MIN, E.VALOR_CUSTO, 
                          E.VALOR_VENDA, (E.VALOR_VENDA-E.VALOR_CUSTO) AS "LUCRO", 
                          F.FORNECEDOR 
                          FROM ESTOQUE E 
                          INNER JOIN FORNECEDOR F
                          ON E.ID_FORNECEDOR = F.IDFORNECEDOR
                          INNER JOIN CATEGORIA C
                          ON E.ID_CATEGORIA = C.IDCATEGORIA
                          ORDER BY E.PRODUTO"""

Does this answer your question? [SQLite: Get Total/Sum of Column](https://stackoverflow.com/questions/12290816/sqlite-get-total-sum-of-column) — shaik moeed, Nov 15 '19 at 07:02
https://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query An [mre] for a database question includes a tailored toy database, in the shape of a few lines of `create table ....` and `insert ...`. — Yunnosch, Nov 15 '19 at 07:03
`try decimal(10, 2)` -> `cast(VALOR_VENDA as decimal(10, 2))` — Ed Bangga, Nov 15 '19 at 07:05

score 0 · Answer 1 · answered Nov 15 '19 at 07:21

0

Work with Printf

printf("%.2f",E.VALOR_VENDA-E.VALOR_CUSTO)

answered Nov 15 '19 at 07:21

Daniel Heringer

11
2

score 0 · Answer 2 · answered Dec 24 '22 at 07:22

0

Seems a sqlite issue instead of python ...

The simple raise and down trick should work.

answered Dec 24 '22 at 07:22

laoyb

99
2
8

Sum columns in Sqlite3

2 Answers2