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
- 8670 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
Is it possible using max on a char column?
How many databases can be created inside an instance in db2 ?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do I delete a table in database?
B37 abend during spufi?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is commit in db2?
When reorg is used?
Is ibm db2 free?
What is the difference between cursor stability and repeatable read isolation levels?
Why do we bind in db2?
What is role in db2?
Explain packages.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
