Add data from a column

Question

id .. product...value...id_sale...total value

01 .. Pen.... 2,00.... 1....... 30,00

02 .. Rubber. 4,00.... 2........... 25,50

03 .. .Lapis...... 5,00.... 1........ 10,00

04 .. Pointer 9,00...1........... 200,00

Good considering this table, I would need to add all the valers of the column valortotal but only those who have the id_venda equal to 1 how I would do it ?

ex : ID_VENDA 1 TOTAL VALUE 240,00 .

Answer 1

Use the command SUM() adding up the values of a column:

SELECT
  SUM(`valortotal`) as 'Valor Total'
FROM
  produtos
WHERE
  id_venda = 1;

See working here: http://sqlfiddle.com/#! 9/bb5d8/2