oracle not a group by expression

Question

I have a table with 3 columns.

ORDER CATEGORY
NAV_PER_SHARE
Number_OUTSTANDING_SHARES

Now:

SELECT ORDER_CATEGORY, SUM(OUTSTANDING_SHARES) GROUP BY ORDER_CATEGORY , it runs fine

But:

SELECT ORDER_CATEGORY, NAV_PER_SHARE * SUM(OUTSTANDING_SHARES) GROUP BY ORDER_CATEGORY , it says : Not a group by expression .

What am I missing?

Possible duplicate of [ORA-00979 not a group by expression](https://stackoverflow.com/questions/1520608/ora-00979-not-a-group-by-expression) — Ben, Dec 10 '17 at 08:07

score 2 · Accepted Answer · answered Mar 28 '11 at 19:16

2

You caNnot group because NAV_PER_SHARE is given per result. Did you mean

SUM(NAV_PER_SHARE*OUTSTANDING_SHARES)

?

answered Mar 28 '11 at 19:16

Howard

score 2 · Answer 2 · edited Nov 08 '12 at 00:07

2

From what it looks like, the solution would be to use a subquery.

SELECT ORDER_CATEGORY, NAV_PER_SHARE * SUM_OF_OS
FROM (SELECT ORDER_CATEGORY, SUM(OUTSTANDING_SHARES) SUM_OF_OS
      GROUP BY ORDER_CATEGORY);

Although, I'm not sure how your one query works without a FROM keyword.

edited Nov 08 '12 at 00:07

FThompson

answered Nov 01 '11 at 23:25

Thomas

2 Answers2