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.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is an index in sql with example?
How many types of triggers are there in pl sql?
How many joins can you have in sql?
What are the methods of filing?
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
What is oracle sql developer?
Does pl sql work in mysql?
What are %type and %rowtype for?
Define commit?
what is an extent ? : Sql dba
What do you mean by stored procedures? How do we use it?
what is sql and plsql