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
- 8888 Views
- I also Faced
- E-Mail Answers
Answer Posted / austin
MADHURI IS CORRECT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a db2 schema?
How would you find out the total number of rows in a db2 table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the default page size of buffer pools?
Name the various locking levels available?
What is data manager?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How to resolve deadlock issue
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is db2 bind?
Explain about rct in db2?
What is db2 plan table?
What is dbrm?
What do you mean by storage group (stogroup)?
What is dclgen (declaration generator)?
