Sign Up Login


  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 / kavitha neditunta

Answer Posted / kavitha neditunta

select
count(decode(val,null,1)) all_null_val
FROM
(select * from t1) UNPIVOT INCLUDE NULLS ( VAL for(
all_null_val) in ( a as 'a', b as 'b', c as 'c', d as 'd') )

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we edit a view in sql?

715

What is the difference among union, minus and intersect?

739

What is bulk compiling in pl/sql.?

801

Compare sql & pl/sql

776

Differentiate between sga and pga.

883

Does sql profiler affect performance?

734

what is dbms? : Sql dba

740

Which table is left in left join?

718

What can you do with pl sql?

775

how to use 'mysql' to run sql statements? : Sql dba

742

What are the benefits of pl sql?

777

How long it takes to learn pl sql?

725

What is data type in sql?

732

Explain the insert into statements in sql?

734

What is the use of desc in sql?

698