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 are the built in functions of sql?

1030

What are reports usually used for?

1024

What is sql engine in oracle?

994

Explain the insert into statements in sql?

1010

What are sql built in functions?

940

Does sql require a server?

1019

Can you inner join the same table?

995

What is the use of index in hive?

1007

What is aggregate function in sql?

1041

What is sequence in sql?

1027

what is query cache in mysql? : Sql dba

1040

Is truncate ddl or dml?

992

How to handle bulk data?

1317

What is dialect in sql?

953

What is secondary key?

935