How to get the sum of an entire column in SQLSERVER

Question

How to get the sum of an entire column in SQLSERVER

Navigation

#1 by (4 votes)
#2 by (1 votes)

1

I need to get the total value of the VOL field (image below), it is already generated by the SUM function. It can be in another query. All periodic tithe is required.

ex: total = VOL (7.6890028) - > sum of the 4 lines of column VOL

sql sql-server query sum

asked by anonymous 03.05.2018 / 21:56

2 answers

1

You can do something like this

Select sum(a.VOL) from ( 
    *SUA QUERY AQUI*) a

03.05.2018 / 22:06

How to avoid array overflow in C ++? Query in two tables

score 4 · Accepted Answer

4

Something like:

Select campo1,
       sum(valor1) valor
from tabela
group by cube (campo1)

03.05.2018 / 22:12