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?
Answer Posted / austin
MADHURI IS CORRECT.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does reorg do in db2?
What are host variables in db2?
What is cloudant database?
Explain about rct in db2?
What is db2 instance?
What is dbrm library?
Can you use max on a char column?
What is node in db2?
List some fields from sqlca?
can we view the access paths created by dbrm ? how ? thx
What is db2 purescale?
How to rename a table in DB2 ?
How can deadlocks be resolved?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Which component is responsible for processing sql statements and selecting access paths?