18

I've got a question regarding a SQL-select-query: The table contains several columns, one of which is an Integer-column called "size" - the task I'm trying to perform is query the table for the sum of all rows (their values), or to be more exact get a artifical column in my ResultSet called "overallSize" which contains the sum of all "size"-values in the table. Preferable it would be possible to use a WHERE-clause to add only certain values ("WHERE bla = 5" or something similar).

The DB-engine is HSQLDB (HyperSQL), which is compliant to SQL2008.

Thank you in advance :)

Peter Lang
  • 54,264
  • 27
  • 148
  • 161
ThE_-_BliZZarD
  • 722
  • 2
  • 12
  • 26

3 Answers3

17
SELECT SUM(size) AS overallSize FROM table WHERE bla = 5;
Michael Mrozek
  • 169,610
  • 28
  • 168
  • 175
11

It's not as simple as this, is it?

SELECT SUM(SIZE)
FROM Table
WHERE bla = '5'
Paddy
  • 33,309
  • 15
  • 79
  • 114
3

Are you looking for:

SELECT SUM(Size) FROM MyTable WHERE bal = '5'

You can also (in MSSQL)

SELECT Size, COl1, COl2 FROM MyTable WHERE bla ='5' COMPUTE SUM(Size)
cjk
  • 45,739
  • 9
  • 81
  • 112