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
- 6679 Views
- I also Faced
- E-Mail Answers
Answer Posted / i go crazy
MADHURI IS CORRECT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is scrollable cursor in db2?
On which levels locks can be applied?
What is the difference between drop table and delete table?
Is db2 free?
What is load replace in db2?
What does db2 stand for?
Where can you declare a cursor in a cobol-db2 program?
What is the reason behind not using select * in embedded sql programs?
What is a trigger in the db2 database?
What is a collection in db2?
What is cursor stability in db2?
How does coalesce work?
What is runstats utility in db2?
Why do we need reorg in db2?
What is a db2 collection?
