Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Does Group By Cause ORA-01403: no data found
Hi,
it's vice versa. The columns in the select list not included in the group
functions must appear in the group by list.
As to the problem: I guess it's because in the first case you count the rows
in the whole table and because count ignores nulls you get the expected
results; in the second case, the count should be done for each group, but
there are no groups to process (due to the dummy is null condition).
Hth,
Pavel
Received on Thu Nov 12 1998 - 01:20:45 CST