Thread

group by problem

Shiby Thomas <sthomas@cise.ufl.edu> — 1998-02-20T18:55:29Z

Hi,

I get the foll. error for a group by query:
This is with the snapshot of Feb 20, and I am running on sparc-solaris 2.6

insert into FTemp1 select item as item1, count(*) as cnt from data group by 
item;
ERROR:  The field being grouped by must appear in the target list

Thanks
--shiby