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

Answer Posted / mani

SELECT A+B+C+D FROM
( select
count(decode(A,null,1)) A,
COUNT(DECODE (B,null,1))B,
COUNT(DECODE (C,null,1))C,
COUNT(DECODE(D,null,1)) D
from PRACTICE2);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql port 1433 encrypted?

778

What is a parameter query?

820

Mention what does plv msg allows you to do?

853

How can I see all tables in sql?

727

What is a trigger word?

727




describe transaction-safe table types in mysql : sql dba

701

Can you have more than one key in a database?

686

how would you enter characters as hex numbers? : Sql dba

713

what is oltp (online transaction processing)? : Sql dba

721

What are joins in sql?

719

What is string data type in sql?

724

What is the use of %rowtype?

743

Explain what is a subquery ?

847

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

690

How much does sqlite cost?

723