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 rownum?

1034

How exception handling is done in advance pl/sql?

1024

Does google use sql?

1008

What is server name sql?

1208

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1135

Which language is used in sql?

1122

what happens if you no create privilege in a database? : Sql dba

1050

What are pl/sql cursor exceptions?

1168

Which are the different character-manipulation functions in sql?

1113

What is time based sql injection?

1036

What is primary key sql?

1112

What does stand for in sql?

1026

what are properties of a transaction? : Sql dba

1139

how do you login to mysql using unix shell? : Sql dba

1130

What type of database is sql?

1068