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.
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
Can unique keys be null?
What is difference between stored procedures and application procedures?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What version is sql?
Can we create view in stored procedure?
Differentiate between syntax and runtime errors.
Can instead of triggers be used to fire once for each statement on a view?
What are the most important characteristics of pl/sql?
How to order siblings in oracle hierarchy queries?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is localdb mssqllocaldb?
How can I speed up sql query?
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 a view be mutating? If yes, then how?
how to load data files into tables with 'mysqlimport'? : Sql dba