SQL query to display before specified date

Question

I am trying to get the sum of all sale prices before a specified date, I have tried the following.

SELECT SUM (Sale_Price), Sale_Date
FROM sales
GROUP BY Sale_Price, Sale_Date
WHERE Sale_Date < '2015-10-12';

However I keep getting "SQL command not properly ended". Any help would be greatly appreciated.

Gordon Linoff · Accepted Answer · 2016-01-09 23:47:43Z

4

If you want the sum for all the dates, then you would use:

SELECT SUM(Sale_Price)
FROM sales
WHERE Sale_Date < DATE '2015-10-12';

You only need the GROUP BY if you want one row for each dae.

answered Jan 9, 2016 at 23:47

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Comments

juergen d · Accepted Answer · 2016-01-09 23:39:59Z

3

SELECT Sale_Date, SUM(Sale_Price)
FROM sales 
WHERE Sale_Date < DATE '2015-10-12'
GROUP BY Sale_Date

answered Jan 9, 2016 at 23:31

juergen d

205k40 gold badges303 silver badges377 bronze badges

"literal does not match format string" I am using the DATE format in the DB, entered in the YYYY-MM-DD format.

Try DATE '2015-10-12'