SUM expression expression not working

Question

Navigation

#1 by (5 votes)

3

I'm trying to make a SUM in a query that performs some calculations. Here's the example:

SELECT
 SUM ( (qtd - qtd_devolucao) * valor AS total)
FROM
 produtos
WHERE
 id_pedido = '47'

I'm having the following error:

# 1064 - You have a syntax error in your SQL next to 'AS total'

mysql sql

asked by anonymous 28.07.2017 / 13:16

1 answer

score 5 · Accepted Answer

To give a name to the sum it should be out of parentheses, should be the last thing of the expression:

SELECT SUM((qtd - qtd_devolucao) * valor) AS total
   FROM produtos
   WHERE id_pedido = '47'