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
21767 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 are sql data types?

965

Show code of a cursor for loop.

1018

What are stored procedures in mysql?

985

What is the use of procedures?

936

What is database migration?

928

What is trigger point?

959

Can a primary key be a foreign key?

982

Is postgresql a nosql database?

1105

how would you enter characters as hex numbers? : Sql dba

955

What are string functions in sql?

1189

How do I find duplicates in the same column?

1017

How do I view tables in mysql?

925

What is Collation Sensitivity ? What are the various type ?

919

How to pronounce postgresql?

1019

What is bulk compiling in pl/sql.?

1084