select sum(case when A is null then 1 when B is null then 1 when C is nul

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

Answer Posted / ash

select sum(case when A is null then 1 when B is null then 1
when C is null then 1 when D is null then 1 else 0 end)as
count_null from table T

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

explain the advantages and disadvantages of stored procedure? : Sql dba

709

how can you create an empty table from an existing table? : Sql dba

858

What is pl sql script?

731

Explain what is a database?

811

What does <> sql mean?

711

How to execute a stored procedure?

755

What is trigger explain it?

738

How is sql used in oracle?

756

What are sql procedures?

757

Is and as keyword in pl sql?

686

What are the benefits of stored procedures?

708

how to create a test table in your mysql server? : Sql dba

684

What is record in pl sql?

768

What is sap sql?

717

How to fetch alternate records from a table?

865