Re: ORA - 00979 Error, why ?

On 26 Nov 2004 10:57:01 -0800, "suckerluv" <paranoidandroid_at_mynet.com> wrote:

>I am getting "not a group by expression" for the following query
>
>select per.kurumunvanref, count(*) from Personel per group by
>per.kurumunvanref
>
>
>Please suggest your ideas and solutions
>Onur
>

Cannot confirm your observation on Oracle 10.1.0.3, which version are you running? :

SQL> create table personel (kurumunvanref number,c2 number,c3 number);

Tabel er oprettet.

SQL> select per.kurumunvanref, count(*) from Personel per group by   2 per.kurumunvanref
  3 ;

Ingen rµkker er valgt

SQL> insert into personel values (1,2,3);

1 rµkke er oprettet.

SQL> select per.kurumunvanref, count(*) from Personel per group by   2 per.kurumunvanref
  3 ;

KURUMUNVANREF COUNT(*)
------------- ----------

            1 1

• Kenneth Koenraadt