SQL - Add up all row-values of one column in a singletable

sql sum hsqldb
ThE_-_BliZZarD picture ThE_-_BliZZarD · Apr 13, 2010 · Viewed 70.6k times · Source

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 :)

Answer

Michael Mrozek picture Michael Mrozek · Apr 13, 2010 
SELECT SUM(size) AS overallSize FROM table WHERE bla = 5;

Related questions

SUM of grouped COUNT in SQL Query

I have a table with 2 fields: ID Name -- ------- 1 Alpha 2 Beta 3 Beta 4 Beta 5 Charlie 6 Charlie I want to group them by name, with 'count', and a row 'SUM' Name Count ------- ----- Alpha 1 Beta 3 Charlie 2 SUM 6 How would I …

Read More
SQL not a single-group group function

When I run the following SQL statement: SELECT MAX(SUM(TIME)) FROM downloads GROUP BY SSN It returns the maximum sum value of downloads by a customer, however if I try to find the social security number that that max …

Read More
How can I use SUM() OVER()

I can't understand this code's bug ID AccountID Quantity 1 1 10 Sum = 10 2 1 5 = 10 + 5 = 15 3 1 2 = 10 + 5 + 2 = 17 4 2 7 = 7 5 2 3 = 7 + 3 = 10 SELECT ID, AccountID, Quantity, SUM(Quantity) OVER (PARTITION BY AccountID ) AS TopBorcT, FROM tCariH

Read More