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.
Answer Posted / mani
SELECT A+B+C+D FROM
( select
count(decode(A,null,1)) A,
COUNT(DECODE (B,null,1))B,
COUNT(DECODE (C,null,1))C,
COUNT(DECODE(D,null,1)) D
from PRACTICE2);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the types of subquery? : Sql dba
Does a user_objects view have an entry for a trigger?
Difference between truncate, delete and drop commands?
How does index help in query performance?
What is rank function in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What are the operators used in select statements?
What is the purpose of primary key?
How exception is different from error?
Can a foreign key have a different name?
what's the difference between a primary key and a unique key? : Sql dba
Explain the advantages and disadvantages of stored procedure?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is before and after trigger?
how to use myisamchk to check or repair myisam tables? : Sql dba