SELECT SUM( CASE WHEN A IS NULL THEN 1 ELSE

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 / chiranjib

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

Answer Posted / chiranjib

SELECT SUM( CASE WHEN A IS NULL THEN 1
ELSE
CASE WHEN B IS NULL THEN 1
ELSE
CASE WHEN C IS NULL THEN 1
ELSE
CASE WHEN D IS NULL THEN 1
ELSE
0
END
END
END
END ) Tot_Null
FROM T
/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning and sharding?

1004

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2277

What are the advantages of pl sql?

1122

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1036

What is parameter substitution in sql?

1023

What is difference between cursor and trigger?

1070

Is null operator in sql?

1027

Can you rollback after commit?

975

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

996

How do I find sql profiler?

933

What is difference between sql and excel?

1087

What is implicit cursor in pl sql?

1090

How do I create a sql database?

992

What is the purpose of my sql?

943

Which table is left in left join?

1011