Re: Sum by date
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 Oct 2001 23:38:17 +0200
Message-ID: <tsmmldtcmllk43_at_corp.supernews.com>
Date: Mon, 15 Oct 2001 23:38:17 +0200
Message-ID: <tsmmldtcmllk43_at_corp.supernews.com>
"sgupta" <sugandha_g_at_yahoo.com> wrote in message
news:62deede6.0110150901.7c528618_at_posting.google.com...
> Hi
>
> I have a number of books sold on 1 day . I want to create a report of
> how many books are sold each day in Oracle. For example
> 10-15-2001 5
> 10-15-2001 6
> 10-15-2001 8
> 10-14-2001 2
>
> how can i generate :
>
> 10-15-2001 19
> 10-14-2001 02
>
> Thanks
>
> SGupta
select trunc(date_column), count(*)
from table
[Quoted] group by trunc(date_column)
Hth,
Sybrand Bakker
Senior Oracle DBA
Received on Mon Oct 15 2001 - 23:38:17 CEST