SELECT COUNT (DECODE ( a, NULL, 'a',DECODE (b,NULL, 'b'

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.

Question Posted / abinash_mishra

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

Please Help Members By Posting Answers For Below Questions

Can unique keys be null?

486

What is difference between stored procedures and application procedures?

572

Is there a way to automate sql execution from the command-line, batch job or shell script?

557

What version is sql?

553

Can we create view in stored procedure?

526

Differentiate between syntax and runtime errors.

642

Can instead of triggers be used to fire once for each statement on a view?

538

What are the most important characteristics of pl/sql?

578

How to order siblings in oracle hierarchy queries?

600

how to use myisamchk to check or repair myisam tables? : Sql dba

509

What is localdb mssqllocaldb?

622

How can I speed up sql query?

525

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

673

Can a view be mutating? If yes, then how?

578

how to load data files into tables with 'mysqlimport'? : Sql dba

524