|
-
To generalize what jmodic said, realize the question you are asking the database:
For each id_number and description, what is the sum of the price? Thus, you must group by those columns. Whenever you use a group function such as sum, max, min, avg . . . you'll need to group by all other non-group-function columns. How else would Oracle be able to determine the "span" or "window" across which to aggregate those values?
Oracle DBA and Developer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|