Re: help for a former sybase user
From: Seth Grimes <grimes_at_access.digex.net>
Date: 21 Sep 1993 06:56:03 -0400
Message-ID: <grimes.748608867_at_access>
> column and an aggregate function. Specifically, I am trying
> to SELECT NAME, COUNT(*) from a table containing a list of names.
> I get the error indicating that the name is "not a single-group
> group function" (error #00937). Sybase allows this returning
Date: 21 Sep 1993 06:56:03 -0400
Message-ID: <grimes.748608867_at_access>
davidsonj_at_gtewd.mtv.gtegsc.com writes:
>a) Why doesn't oracle PL/SQL allow a select that includes both a
> column and an aggregate function. Specifically, I am trying
> to SELECT NAME, COUNT(*) from a table containing a list of names.
> I get the error indicating that the name is "not a single-group
> group function" (error #00937). Sybase allows this returning
You *probably* need to add a "GROUP BY NAME" to your SELECT.
Seth Received on Tue Sep 21 1993 - 12:56:03 CEST