select (count(decode(A,null,1)) + count(decode (B,null,1)) + count(decode(C

i have table T!.

A B C D
NULL 1 2 3
4 NULL 5 6
7 8 NULL 9
10 11 12 NULL.

I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

Question Posted / gaurav

14 Answers
22254 Views
iGate, Wipro, I also Faced
E-Mail Answers

Answer Posted / gaurav

select (count(decode(A,null,1)) + count(decode (B,null,1)) + count(decode(C,null,1) + count(decode(D,null,1))) null_count
from T

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a sql schema used for?

1105

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2500

How subquery works in sql?

1070

What are the different types of a subquery?

1050

How do I run a program in pl sql?

1004

How to connect a sql*plus session to an oracle server?

1128

Is sql workbench free?

1003

What is a trigger word?

1025

What is pl sql collection?

970

What are different types of statements supported by sql?

1165

Explain the uses of a database trigger?

1043

What type of database is sql?

1026

What are character functions in sql?

939

What is a .db file?

986

What is sql server and ase?

1023