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 -> Re: Need query to group by date

Re: Need query to group by date

From: Eric Givler <egivler_at_flash.net>
Date: Thu, 14 Sep 2000 14:31:06 GMT
Message-ID: <Ki5w5.6796$oc3.417662@news.flash.net> 






Use Decode.



Bob McConnell <bob.mcconnell_at_mci.com> wrote in message
news:39BFE46F.D6FAEBE1_at_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 Thu Sep 14 2000 - 09:31:06 CDT












Original text of this message













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