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

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.

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

205k40 gold badges303 silver badges377 bronze badges

2 Comments

"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'