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
- 6676 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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a bind in db2?
what is a corelated subquerry?
What are iseries servers?
How is the value function used?
what are bind concepts in db2 cobol?
Explain in detail about buffer manager and its functionalities?
What is bind in db2?
What is query_cache_limit?
What is db2 look?
What are the bind parameters ibm db2?
What is drop table?
How do I add a column in db2?
What does db2 plan contain?
How connect db2 database to datastage?
