Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Does Group By Cause ORA-01403: no data found

Re: Why Does Group By Cause ORA-01403: no data found

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: Thu, 12 Nov 1998 08:20:45 +0100
Message-ID: <72e2ee$htm$1@cbu.pvtnet.cz>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US