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
- 8668 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 the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is query_cache_limit?
What is a system catalog table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How can you classify the locks in db2?
What is cascading rollback?
What is reorg and runstats in db2?
What does runstats do in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is netezza database?
How many databases can be created inside an instance in db2 ?
How do I delete a table in database?
What is precompiler in db2?
