| GROUP BY problem [message #374882] |
Mon, 09 July 2001 15:47  |
Pavel Aksonov
Messages: 4
Registered: July 2001
|
Junior Member |
|
|
select users.name, sum(info.count) from users, info where users.id=info.id group by info.id,users,id *
ERROR at line 1:
ORA-00979: not a GROUP BY expression
Please help me, clarify why i can't run this SQL statement
|
|
|
|
| Re: GROUP BY problem [message #374910 is a reply to message #374882] |
Wed, 11 July 2001 07:25  |
N.Anandasiva
Messages: 7
Registered: July 2001
|
Junior Member |
|
|
Since you have selected only one column apart from the coloumn used in sum function, it is necessary to include the first coloumn in your query in group by clause.
Regards
N.Anandasiva
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
