Jay Roy
asked on
oracle: not a single-group group function
hi guys
I do
select id, to_char(SUM(salary),'999,9 99,999,999 ') as salary from customer .
customer table has
id salary
I get error
ORA-00937: not a single-group group function
00937. 00000 - "not a single-group group function"
*Cause:
*Action:
any idea? Am i missing GROUP BY clause ? not sure if i need one.
thanks
I do
select id, to_char(SUM(salary),'999,9
customer table has
id salary
I get error
ORA-00937: not a single-group group function
00937. 00000 - "not a single-group group function"
*Cause:
*Action:
any idea? Am i missing GROUP BY clause ? not sure if i need one.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.