Re: Need query to group by date

Bob McConnell napisa³(a) w wiadomoœci: <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
>

Try UNION operator...

Select orderstatus, count(*)

    from XXX
  where orderdate < 30 days
   group by orderstatus
UNION
Select orderstatus, count(*)

    from XXX
  where 30 days < orderdate < 60 days
   group by orderstatus
UNION
Select orderstatus, count(*)

    from XXX
  where orderdate > 60 days
   group by orderstatus;

(sorry for syntax..its not quite correct). buy it may help. Received on Thu Sep 14 2000 - 04:11:35 CDT