SQL HELP

From: Min Wang <mwang_at_colorbank.com>
Date: Thu, 20 Aug 1998 19:52:31 -0400
Message-ID: <35DCB6BF.46B891E7@colorbank.com>

Hi:

I have a query like this:

select count(order_id), order_date

  from order_record
 where order_date > date1
   and order_date < date2

 group by order_date;

What I want is get the numbers of orders for each day from date1 to date2.
But what I get is a individaul order list instead of the sum of order of each day. I guess this may be because I used sysdate when I record the orders. Some orders might be placed in the same day but at different time.

My question is how I can get count(order_id) for each day?

Thanks. Received on Thu Aug 20 1998 - 18:52:31 CDT