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
- 19904 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramesh
select a1+b1+c1+d1 from
(select count(case when a='null' then 1 end) a1,
count(case when b='null' then 1 end) b1,
count( case when c='null' then 1 end) c1,
count(case when d='null' then 1 end) d1 from t1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is left join same as inner join?
Explain what is an index?
What is procedure and function?
Which one is faster ienumerable or iqueryable?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Write a query to find the names of users that begin with "um" in sql?
What are pl/sql packages?
What is the difference between stored procedure and view?
what are set operators in sql? : Sql dba
How to use sql statements in pl/sql?
How many times can we commit in a loop?
What is full form of rtm?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Does varchar need length?
what is union? : Sql dba
