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
- 22240 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / abinash_mishra
SELECT COUNT (DECODE ( a, NULL, 'a',DECODE (b,NULL, 'b',DECODE (c, NULL, 'c', DECODE (d, NULL, 'd', NULL))))) null_count
FROM t_null;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is sql and db2?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How do I create a sql database?
What is pl sql script?
Can you skip header records while loading? : aql loader
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How would you pass hints to the sql processor?
What is the process of debugging?
How can triggers be used for the table auditing?
What is error ora-12154: tns:could not resolve the connect identifier specified?
what is msql? : Sql dba
What is flag in sql?
Does sql profiler affect performance?
What happens when a trigger is associated to a view?
