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
- 8731 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
can we view the access paths created by dbrm ? how ? thx
Comment whether the cursor is closed during commit or not.
What is node in db2?
What is blu acceleration in db2?
What are iseries servers?
How to restart a DB2 program?
What is role in db2?
When do you specify the isolation level?
What is the maximum number of columns in a db2 table?
Define declaration generator (dclgen).
Mention some fields that are a part of sqlca.
What is with ur in db2?
Explain how can you do the explain of a dynamic sql statement?
How can we read records for specific member in CL? AND rpg?
What is catalog database in db2?
