3
I’m trying to make a SUM in a query that performs some calculations. Follow the example:
SELECT
SUM ( (qtd - qtd_devolucao) * valor AS total)
FROM
produtos
WHERE
id_pedido = '47'
I’m having the following mistake:
#1064 - You have a syntax error in your SQL next to 'Total AS')
5
To give a name to the sum it must be out of parentheses, must be the last thing in the expression:
SELECT SUM((qtd - qtd_devolucao) * valor) AS total
FROM produtos
WHERE id_pedido = '47'
See working on SQL Fiddle. Also put on the Github for future reference.
It didn’t work out, keep making the same mistake.
@Hugoborges put a Fiddle showing that it works, you must be doing it wrong, or the question is wrong.
Sorry, the mistake really was mine. It worked 100%, thank you.
Browser other questions tagged mysql sql database
You are not signed in. Login or sign up in order to post.
You want the sum to be called
total?– Maniero
I want to add all the
total– Hugo Borges
And what is the expression that forms the
total?– Maniero
I want the
totalreceives(qtd - qtd_devolucao) * valorThen I want to have asumin thetotal.– Hugo Borges