Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 14 Answers
- 22268 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramesh
select a1+b1+c1+d1 from
(select count(case when a='null' then 1 end) a1,
count(case when b='null' then 1 end) b1,
count( case when c='null' then 1 end) c1,
count(case when d='null' then 1 end) d1 from t1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by temporal data?
What is the difference between functions, procedures, and packages in pl/sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the difference between in and between in sql?
What is the file extension for sql database?
What is time based sql injection?
Can I create table without primary key?
What is a recursive join sql?
Can we use pl sql in mysql?
What steps server process has to take to execute an update statement?
How would you convert date into julian date format?
What is sql*loader and what is it used for?
Is t sql a programming language?
Which are the different character-manipulation functions in sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
