Interested to Buy Any Domain ? << Click Here >> for more details...
If a table has a column "dept" (declared to have nulls) and
there are 10 rows in the table of which 3 have a null value
in the dept column, what will select count(*) and select
count(distinct dept) return?
- 6 Answers
- 8742 Views
- I also Faced
- E-Mail Answers
Answer Posted / keshireddy
Hmm Virender is correct
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why db2 is called db2?
How to check last update on table in db2?
What language is db2 written in?
What is db2 plan table?
How can you classify the locks in db2?
What is the reason behind not using select * in embedded sql programs?
What is db2 connect?
Why select is not preferred in embedded sql programs?
What is database manager in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the use of runstats in db2?
What is a Foreign Key?
can we view the access paths created by dbrm ? how ? thx
How to find schema of a table in db2?
What is innodb buffer pool?
