i have table T!. A B C D NULL 1 2 3 4 NULL 5

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

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

Answers were Sorted based on User's Feedback

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

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

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / kishore vakiti

select sum(decode(a,null,1))+
sum(decode(b,null,1))+
sum(decode(c,null,1))+
sum(decode(d,null,1)) tot_nulls from <TAB-NAME>;

Is This Answer Correct ?

0 Yes

0 No

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / kavitha neditunta

select
count(decode(val,null,1)) all_null_val
FROM
(select * from t1) UNPIVOT INCLUDE NULLS ( VAL for(
all_null_val) in ( a as 'a', b as 'b', c as 'c', d as 'd') )

Is This Answer Correct ?

0 Yes

0 No

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / sreenu

hi naren thank for your ans.

but here i am asking total count of null records. means how
many null values are there.

see above table having 4 null values. i want display "4".

please tell me sql query

Is This Answer Correct ?

0 Yes

2 No

Post New Answer