I have salesorder table in which all the sales orders are stored. here is the design
Order_id Order_qty dealer_id order_price order_date
how do I display sum(order_price) based on the two dates monthwise.
What I mean is say i have two dates 01/01/2005 and 04/01/2005 it should fetch records in the below mentioned manner
Dealer_id Jan'05 Feb'05 Mar'05 Apr'05
1 1000 2000 40000 50000
2 3000 1000 2000 10000