Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries give impossible results
SQL> select count(*) from ci_customer;
COUNT(*)
138295
SQL> SELECT count(*) FROM ci_customer WHERE customer_state = 'ACTIVE';
COUNT(*)
135324
select count(*), filter by customer_state='ACTIVE' and customer_state
not in ('ACTIVE')
If the sum of the last two does not sum up to count(*) then you
either have null columns in your table or may then have a real reason
to worry
Michael Tubuo Ngong Received on Thu Nov 14 2002 - 09:30:52 CST