Re: Counting Null Values
From: <rtproffitt_at_my-deja.com>
Date: 2000/06/22
Message-ID: <8ittgp$m7g$1_at_nnrp1.deja.com>#1/1
Date: 2000/06/22
Message-ID: <8ittgp$m7g$1_at_nnrp1.deja.com>#1/1
Try Summing, like so:
SQL> select
2 count(a) TotCnt,
3 sum( decode(n,NULL,1,0) ) NULLCnt
4 from bobb;
TOTCNT NULLCNT
--------- ---------
72 10
Robert Proffitt
Beckman Coulter
Brea CA
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jun 22 2000 - 00:00:00 CEST