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
- 19955 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gaurav
select (count(decode(A,null,1)) + count(decode (B,null,1)) + count(decode(C,null,1) + count(decode(D,null,1))) null_count
from T
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are schema-level triggers?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is left join same as join?
Explain table and field in sql?
How to install oracle sql developer?
Are stored procedures faster than dynamic sql?
How bulk collect improves performance?
Explain the select statement in sql?
Can ddl statements be used in pl/sql?
Explain the order of sql statement execution?
Why truncate is used in sql?
What are stored procedures in mysql?
What is the process of debugging?
Explain select statements in sql?
