select count(decode(a,null,1)),count(decode(b,null,1)),count(decode(c,null

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 / naren

Answer Posted / naren

select
count(decode(a,null,1)),count(decode(b,null,1)),count(decode(c,null,1)),count(decode(d,null,1))
from t1

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is rownum and rowid?

759

describe mysql connection using mysql binary. : Sql dba

752

What is package in pl sql with an examples?

728

What is pl sql block structure?

719

How to disable a trigger name update_salary?

894

What are the topics in pl sql?

699

What are the steps for performance tuning.

1034

What do you understand by exception handling in pl/sql?

754

What is a system versioned table?

700

what is index? : Sql dba

747

Is sql harder than python?

817

How do I create a memory optimized filegroup?

697

What is the left table in sql?

698

What is crud stand for?

744

What is the unique index?

724