trying to Ggroup by

From: Jawahar Rajan <jrajan_at_nc.rr.com>
Date: Fri, 02 Apr 2004 02:33:53 GMT
Message-ID: <li4bc.3895$w84.618835@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 Received on Thu Apr 01 2004 - 20:33:53 CST