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

what is view? : Sql dba

912

tell us something about heap tables. : Sql dba

1048

What sql does db2 use?

926

What is the most important ddl statements in sql are?

946

What is the limitation on the block size of pl/sql?

936

What is minus?

940

How can use stored procedures in sql?

1079

What is a database event trigger?

1081

What is the difference between the conventional and direct path loader? : aql loader

1111

Explain what is rdbms?

991

How can I make sql query run faster?

960

Explain the working of foreign key?

976

what is the difference between blob and text? : Sql dba

961

Explain the savepoint statement.

1038

How to test for null values?

983