Re: SQL "Group By" question

dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:

> I have a table called XYZ that has a column called date_open (which naturally has the date in which the entry was entered into the table).
>
>I would like to create some sort of report/group by sql statement that will return : July 10, August 23 In other words, a count will be done on each month and will see how many calls were entered into the table. How would this be done? I've tried thinking about the between, but couldn;t figure how to show each month and its number of calls.
>
>Thanks for your help,
>Sean

Hopefully I've understood what you are trying to accomplish...

TRY.... select to_char(date_open,'MONTH'), count(*) group by to_char(date_open,'MONTH');

OR

select to_char(date_open,'MONTH DD, '), count(*) group by to_char(date_open,'MONTH DD');

Cheers, Robert Prendin

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************