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

How do you remove duplicates without using distinct in sql?

695

What does trigger mean in psychology?

708

Explain autonomous transaction.

842

How many types of triggers are there in pl sql?

781

What is the difference between Union and Union all. Which is faster.

1064

How do I save a stored procedure?

729

What is a data definition language?

791

Is pl sql and postgresql same?

767

Is grant a ddl statement?

635

what is an extent ? : Sql dba

751

tell us something about heap tables. : Sql dba

819

What are all types of user defined functions?

736

How would you pass hints to the sql processor?

704

Is pl sql a scripting language?

779

Can we use insert statement in function?

735