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
- 6677 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhilash
SELECT(*) Will return 10 and SELECT (distinct dept) will
return 8.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to restart a DB2 program?
What is database manager in db2?
List out the buffer pools in db2
What do you mean by commit and rollback?
What os does db2 run on?
What is db2 plan table?
What is the difference between oracle and db2?
How do you find the maximum value in a column in db2?
How to check table size in db2 sap?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
what is utility for parm lib
Explain about rct in db2?
What is dclgen in db2?
Which isolation level provides maximum concurrency?
What is host variable in db2 cobol?
