Re: not a single-group group function ?

Basically, anything in your SELECT list that isn't an aggregate must also appear in a GROUP BY clause. Therefore try this:

SELECT to_char(renewal_date), count(*)
FROM foreign_worker_master
GROUP BY to_char(renewal_date);

HTH JR

On Wed, 27 Oct 1999 03:59:01 GMT, javanewbie_at_my-deja.com wrote:

>when i do this in the oracle, it says :-
>
>select to_char(renewal_date),count(*)
> from foreign_worker_master";
>
>question 1 : what's wrong ?
>
>executeQuery() Failed:
> Message: ORA-00937: not a single-group group function
>
> Vendor: 937
>
>question 2 : how do i group all the dates that begin with
>
>28-NOV-99
>30_NOV-99
>
>to be 1 group ?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Oct 27 1999 - 05:59:27 CDT