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
- 8486 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhuri tungal
select count(*) returns 10 --- this is right. But,
select count(distinct dept) returns 7. Because null values
are not considered as distinct.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is meant by explain?
What is database reorganization?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is reorg?
Why do we bind in db2?
How do I delete a table in database?
How would you find out the total number of rows in a db2 table?
Explain db2.
What is db2 stogroup?
What is scrollable cursor in db2?
What is consistency token in db2?
What is universal database?
What is release/acquire in bind?
How do I copy a table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
