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 #370797] Wed, 09 February 2000 02:40
Atavur Rahaman
Messages: 1
Registered: February 2000
Junior Member
Hello Kurkj,

Good Day!..

I think this will also works.......

SQL> Select Id,Decode(Col1,NULL,1,NULL) COLUMN1,
Decode(Col2,NULL,1,NULL) COLUMN2, Decode(Col3,NULL,1,NULL) COLUMN3, Decode(Col4,NULL,1,NULL)COLUMN4 From Table_Name;

And by using Table Alias Names we can also proceed....

Regards
Atavur Rahaman S.A

Report message to a moderator

Previous Topic: Re: URGENT Syntax question Dynamic SQL.
Next Topic: REF and MULTISET
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 19:49:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.