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
- 21645 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
What is relationship? How many types of relationship are there?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Do prepared statements prevent sql injection?
Where is sql database stored?
Are sql connections encrypted?
what are the advantages and disadvantages of views in a database? : Sql dba
how to see the create table statement of an existing table? : Sql dba
How to write pl sql program in mysql command prompt?
How many commands are there in sql?
What are the syntax and use of the coalesce function?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can we rollback delete command?
what is oltp (online transaction processing)? : Sql dba
what are date and time intervals? : Sql dba
Explain the uses of a database trigger?
