Home » RDBMS Server » Server Administration » Re: count number of nulls in column for each row
Re: count number of nulls in column for each row [message #370794] Tue, 08 February 2000 22:08
mathuri
Messages: 1
Registered: February 2000
Junior Member
You could use a decode statement
select ID, sum(decode(Id,NUll,1,0) 'ID Count',
sum(decode(speed,NULL,1,0) 'speed count',
from table
group by ID;

let me know if it works
Previous Topic: New Visual Basic Site
Next Topic: Re: URGENT Syntax question Dynamic SQL.
Goto Forum:
  


Current Time: Thu Oct 22 05:03:22 CDT 2020