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
- 22700 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naren
select
count(decode(a,null,1)),count(decode(b,null,1)),count(decode(c,null,1)),count(decode(d,null,1))
from t1
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the different types of functions in sql?
What is procedure and function?
How do I find duplicates in the same column?
Is sql the best database?
what is a database lock ? : Sql dba
how to include character strings in sql statements? : Sql dba
Why we use cross join?
What is set transaction?
What is sql injection owasp?
Can you do multiple joins in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What are the advantages of pl sql?
What is anonymous block in sql?
Explain what is a view?
What is sql and also describe types of sql statements?
