Re: trying to Ggroup by

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 02 Apr 2004 03:42:46 GMT
Message-ID: <Wi5bc.3150$Bp2.2922@nwrdny02.gnilink.net>

"Jawahar Rajan" <jrajan_at_nc.rr.com> wrote in message news:li4bc.3895$w84.618835_at_twister.southeast.rr.com...
> All,
> I have data of people's birth
> I am trying to group byno of births per week
> I have in a table ID, Birth_Date, Gender, initials, site
> I want to group by births per week per site
>
> Is there an Oracle function for grouping by Week
>
> Select Count(id),site
> From birth_Table
> group by birth_Date, site
>
> Do I need to get the difference betweeen the Max and min dates and then
> divide by 7 and see how manydate fall in each week category?
>
> ANy help is appreciated
> Jawahar
>
>

go to tahiti.oracle.com

browse the documentation .. go to the sql reference guide ... look for sql functions like to_char(date), trunc(date).

Read ... learn fishing for answers yourself.

Anurag Received on Thu Apr 01 2004 - 21:42:46 CST