Add up values from table columns in SQL

Question

Is it possible in PostgreSQL to select one column from a table within a particular date span (there is a date column) and - here is the catch! - add the table together. Like for making a sales report?

SELECT amount FROM sales_orders WHERE date BETWEEN 11-03-06 & 11--04-06 and add them together... — 1252748
– 1252748, Commented Aug 8, 2012 at 20:18
INSERT INTO tbl_a SELECT date_fld FROM tbl_b WHERE CAST(date_fld AS DATE) BETWEEN '2012-01-01' AND '2012-01-31' but it sounds you may want a join? — T I
– T I, Commented Aug 8, 2012 at 20:22

Erwin Brandstetter · Accepted Answer · 2012-08-09 00:18:31Z

1

Based on your comment, I think you are referring to SUM(). This is an aggregate function

SELECT SUM(amount) FROM sales_orders WHERE date BETWEEN '2011-03-06' and '2011-04-06' -- not sure what your date is.

edited Aug 9, 2012 at 0:18

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

answered Aug 8, 2012 at 20:20

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

1252748 Over a year ago

oops..meant to post this comment to you : razorsql asked me to enter a parameter value for & ..what does that mean?

Taryn Over a year ago

@thomas you need to use AND between your dates not &.

Taryn Over a year ago

@thomas you need to place you dates in the correct format yyyy-mm-dd

Erwin Brandstetter Over a year ago

Please link to the current version of the manual. Postgres 8.1 has been out of business for quite a while now. If you don't need to address a particular version, it's probably best to point to http://www.postgresql.org/docs/current/interactive/.

Taryn Over a year ago

@ErwinBrandstetter agreed. That was the link I got when I tried to find aggregate function. I should have verified it was functioning when I posted. Thanks for the edit.

|

D'Arcy Rittich · Accepted Answer · 2012-08-08 20:19:06Z

0

If I understand you correctly, you are looking for this:

SELECT sum(amount) FROM sales_orders WHERE date ...

answered Aug 8, 2012 at 20:19

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

1 Comment

1252748 Over a year ago

my razorsql asked me to enter a parameter value for & ..what does that mean?

Collectives™ on Stack Overflow

Add up values from table columns in SQL

2 Answers 2

7 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Related