Which one allows duplicate values Union or Union All ?
Answer Posted / naveen87ginjupalli
Union All allows duplicate values.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Is db2 a programming language?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What do you mean by between and in? Is between inclusive of specified range values?
What are bind parameters in db2?
How do we specify index to include or not during bind process.
How will you return the number of records in table?
How does coalesce work?
How can you find out the # of rows updated after an update statement?
What is data manager?
How do you stop a db2 database in linux?
What is blu acceleration in db2?
Explain various types of locks in db2?
What is catalog database in db2?
What is bind package and plan 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