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
Is db2 relational database?
When reorg is used?
What is the clustering index in the db2 database?
What is check constraint in db2?
What does db2 plan contain?
How to get the ddl of a table in db2?
What is the role of union all and union
What is a db2 package?
What is runstats and reorg in db2?
What is copy pending status in db2?
What is temporal table in db2?
What is precompiler in db2?
What is lock escalation in db2?
How does cobol compile db2 program?
Explain packages.