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
- 8534 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
How can deadlocks be resolved?
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
How can you quickly find out the # of rows updated after an update statement?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I delete a table in db2?
What is bind in db2?
How many databases can be created inside an instance in db2 ?
What is dbrm? What it contains?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the benefits of using the db2 database?
What is a cursor in programming?
How to find the number of rows in db2 tables?
Explain about mirror activator disk mirroring?
Which is faster delete or truncate?
What is catalog database in db2?
