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
- 6649 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 do you mean by cursor?
What is consistency token in db2?
Explain the benefits you can get from mainframe connect?
Are view updateable?
How do I delete a table in db2?
What is host variable in db2 cobol?
What is page size in db2?
What is a system catalog table in db2?
What do you mean by storage group (stogroup)?
How does cobol compile db2 program?
How can deadlocks be resolved?
What is the meaning concurrency in the db2 database?
What is the role of data manager in the db2 database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is a bind in db2?
