i want to build a table output that is ordered like this:
http://rzserv2.fhnon.de/~lg016500/untitled1.bmp
(the <10, <100 etc is just an example - i want it to be seperatet by different dates)
I want to fill out the blanks, but i dont know how i have to do the SELECTs.
It could be done like this:
Code: Select all
SELECT sum(tovalue) from sam_date_val group by actdeldate BETWEEN DATE '2003-01-01' AND DATE '2005-08-08' AND actdeldate BETWEEN DATE '2005-09-09'AND DATE '2015-08-08'joe