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

Report message to a moderator

Previous Topic: New Visual Basic Site
Next Topic: Re: URGENT Syntax question Dynamic SQL.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 09:04:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.