Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Need query to group by date

Need query to group by date

From: Bob McConnell <bob.mcconnell_at_mci.com>
Date: Wed, 13 Sep 2000 20:34:12 GMT
Message-ID: <39BFE46F.D6FAEBE1@mci.com> 






I have a table of ORDERS which has an OrderDate field and an OrderStatus
field.  I would like to query to get orders <30 days, 30 to 60days, 60
to 90days and > 90  grouped by Orderstatus.  How would I do that?



thanks


Bob
Received on Wed Sep 13 2000 - 15:34:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US