Newbie question: deleted rows less than selected

From: <jose_luis_fdez_diaz_news_at_yahoo.es>
Date: 19 Oct 2005 00:32:07 -0700
Message-ID: <1129707127.581482.224460@g47g2000cwa.googlegroups.com>

Hi,

SQL> select GPRS_CO_MSISDN from GPRS_SERVICIO_GPRS 2 where NOT EXISTS (select 1 from SAPN_SERVICIO_APN where SAPN_CO_MSISDN = GPRS_SERVICIO_GPRS.GPRS_CO_MSISDN) 3 group by GPRS_CO_MSISDN;

105005 rows selected

SQL> delete from GPRS_SERVICIO_GPRS
2 where NOT EXISTS (select 1 from SAPN_SERVICIO_APN where SAPN_CO_MSISDN = GPRS_SERVICIO_GPRS.GPRS_CO_MSISDN); 103962 rows deleted

In the table GPRS_SERVICIO_GPRS is possible that exists several rows with the same GPRS_CO_MSISDN.

Why are "rows deleted" < "rows selected" ?

Thanks in advance,
Jose Luis. Received on Wed Oct 19 2005 - 02:32:07 CDT