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

What is the difference between view and stored procedure?

496

explain the delete statements in sql

583

When do we use triggers?

585

When are we going to use truncate and delete?

554

What is group by in sql?

550

Does mysql support pl sql?

624

How do I install microsoft sql?

531

What is difference between procedure and trigger?

519

Can a varchar be a primary key?

536

What is a constraint? Tell me about its various levels.

639

explain about mysql and its features. : Sql dba

554

What are joins in sql?

541

What is sql in oracle?

625

What are stored procedures in mysql?

565

What is the life of an sql statement?

525