1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Answer Posted / ramesh

select a1+b1+c1+d1 from
(select count(case when a='null' then 1 end) a1,
count(case when b='null' then 1 end) b1,
count( case when c='null' then 1 end) c1,
count(case when d='null' then 1 end) d1 from t1)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between syntax and runtime errors.

642

what is the use of friend function? : Sql dba

543

How to add, remove, modify users using sql?

560

List the different type of joins?

571

What is meant by <> in sql?

509




What is materialized view in sql?

465

Mention what does the hierarchical profiler does?

561

Does view store data in sql?

535

Is it possible to update views?

542

What is posting?

609

How many times can we commit in a loop?

566

tell us something about heap tables. : Sql dba

603

What are inner and outer joins examples of both?

497

How to pronounce postgresql?

582

Why do we need pl sql?

550