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
- 22159 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / abinash_mishra
SELECT a_null + b_null + c_null + d_null
FROM (SELECT COUNT (DECODE (a, NULL, 1, NULL)) a_null,
COUNT (DECODE (b, NULL, 1, NULL)) b_null,
COUNT (DECODE (c, NULL, 1, NULL)) c_null,
COUNT (DECODE (d, NULL, 1, NULL)) d_null
FROM t_null);
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is meaning of <> in sql?
What are database links used for?
How to create an array in pl/sql?
what is transaction? : Sql dba
Does user triggers have entry for trigger with compilation errors?
What is sql trigger example?
Is id a reserved word in sql?
How many functions are there in sql?
What is a trigger word?
What is posting?
What are the most important characteristics of pl/sql?
what does the t-sql command ident_incr does? : Transact sql
What are sql triggers used for?
What is the difference between inner join and left join?
What are the limitations of sql express?
