I have written a query like this:
select to_char(order_date,'mon-yyyy') "months", sum(nob) "number of bags"
from p_in where order_date between '1-apr-11 and '31-mar-12'
group by to_char(order_date,'mon-yyyy')
The above query returns me a resultset which gives me number of bags sold in every
month, but it does not sort the month in their chronological order.I want to sort my resultset in ascending order of month s.,means jan-feb-march-apr-may ams so on...