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
- 8889 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
Name the lockable units in DB2?
What is the purpose of rollback and commit?
what is db2 restart?
What is clone table?
Before you give the explain statement, what are the prerogatives?
Explain about mirror activator disk mirroring?
What are the rules for db2 programming?
What is bind package and plan in db2?
How to access db2 tables in mainframe?
What is ibm db2 client?
Explain in detail about buffer manager and its functionalities?
What is the role of schema in the db2 database?
How to get the ddl of a table in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a db2 collection?
