Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 14 Answers
- 22205 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why are aggregate functions called so?
how to shutdown mysql server? : Sql dba
Can a table have no primary key?
What is a primary key example?
Explain the purpose of %type and %rowtype data types with the example?
what are the differences between char and nchar? : Sql dba
How do you delete data from a table?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Which is better varchar or nvarchar?
What are the different types of dbmss?
what is rdbms? : Sql dba
What is indexing in sql and its types?
What is left join example?
How can you view the errors encountered in a trigger?
Is postgresql a server?
