SUM returns NULLs
Hi,
I have a query which returns 7 rows of NUMBER values. I put this query as sub-query which returns SUM of this 7 rows, simply:
select sum(x)
from (........the query that returns 7 rows of NUMBER values........)
the result should be one row with sum of seven rows, but it returns seven empty rows -NULLS-.
What can be the problem?
Saad,