Hello,
Apologies in the wrong form I did some MS SQL before I am have problems with Oracle syntax
I search for ways to do this I know probably lost of ways to get the results.
Adding Amount by quarters (Q#) Q1, Q2, Q3, Q4
Have a tables Sales
SalesID Date (01-MON-YYYY) Amount
Select Date, Sum (Amount)
From Sales
ORDER_DATE BETWEEN '01-Jan-13' AND '31-Mar-2013' Q1
--ORDER_DATE BETWEEN '01-Apr-2013' AND '30-Jun-2013' Q2
--ORDER_DATE BETWEEN '01-Jul-2013' AND '30-Sep-2013' Q3
--ORDER_DATE BETWEEN '01-Oct-2013' AND '31-Dec-2013' Q4
>>>>
If I run
SELECT order_date, SUM (order_amount ) TOTAL This give me Q1 no Total and cannot fun a 4 Dates same time I remember signing functions o=in MS SQL or a declare
ORDER_DATE BETWEEN '01-Jan-13' AND '31-Mar-2013
GROUP BY order_date;
<<<<<<<<
I want results like
Q1 Q2 Q3 Q4
--------------------------------------------
1 45 600 25 |-------------
2 45 25 25 | these are Amount of sales by date
23 10 25 25 |___________
---------------------------------------------------------
Totals 26 100 650 75
Thank You,
Paul Rozee
p_rozee@hotmail.com