Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answers were Sorted based on User's Feedback



i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / chiranjib

SELECT SUM( CASE WHEN A IS NULL THEN 1
ELSE
CASE WHEN B IS NULL THEN 1
ELSE
CASE WHEN C IS NULL THEN 1
ELSE
CASE WHEN D IS NULL THEN 1
ELSE
0
END
END
END
END ) Tot_Null
FROM T
/

Is This Answer Correct ?    0 Yes 0 No

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / kishore vakiti

select sum(decode(a,null,1))+
sum(decode(b,null,1))+
sum(decode(c,null,1))+
sum(decode(d,null,1)) tot_nulls from <TAB-NAME>;

Is This Answer Correct ?    0 Yes 0 No

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

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

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL ..

Answer / sreenu

hi naren thank for your ans.

but here i am asking total count of null records. means how
many null values are there.

see above table having 4 null values. i want display "4".

please tell me sql query

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

wtite down triggr not any entry on Sunday

2 Answers   NIT,

What are the different types of constraints?

0 Answers  

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

What is sql character function?

0 Answers  

What are pl/sql cursor exceptions?

0 Answers  

Explain cursor types?

0 Answers  

What is sql*loader?

0 Answers  

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

tell me about various levels of constraint. : Sql dba

0 Answers  

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

Define tables and fields in a database

0 Answers  

How to select unique records from a table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories