query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

query

Author

Topic

dsa09
Starting Member

1 Post

Posted - 2008-02-24 : 22:53:16

SQL> select diner,odate,sum(serves.price) from ordera3, serves where diner='JANU
SZ' and odate='14-jan-2007';
select diner,odate,sum(serves.price) from ordera3, serves where diner='JANUSZ' a
nd odate='14-jan-2007'
*
ERROR at line 1:
ORA-00937: not a single-group group function

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-24 : 22:59:52

Looks like oracle code.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-25 : 04:04:26

quote:
Originally posted by dsa09

SQL> select diner,odate,sum(serves.price) from ordera3, serves where diner='JANU
SZ' and odate='14-jan-2007';
select diner,odate,sum(serves.price) from ordera3, serves where diner='JANUSZ' a
nd odate='14-jan-2007'
*
ERROR at line 1:
ORA-00937: not a single-group group function

You need to use group by diner,odate
Post oracle questions at www.orafaq.com

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources