Home » RDBMS Server » Server Administration » not a single-group group function
not a single-group group function [message #370658] Mon, 17 January 2000 11:06
Chris
Messages: 128
Registered: November 1998
Senior Member
Hi there,

Could someone tell me how to sum a field I have without getting the 'not a single-group group function' error?

This is the SQL I have. As you can imagine the query works beautifully without the sum. I would also like to group it by either the 'PRICING_PLAN_NUMBER' (a.k.a.

Report message to a moderator

Previous Topic: Issue of Update for a record in a Database Block
Next Topic: Connecting to a remote db within PL/SQL Procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 14 17:57:45 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.