Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sanjudharan
UNION : eliminates duplicates
UNION ALL: retains duplicates
Both these are used to combine the results of different
SELECT statements.
Suppose I have five SQL SELECT statements connected by
UNION/UNION ALL, how many times should I specify UNION to
eliminate the duplicate rows? -
Once.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
What is db2 stogroup?
What is check constraint. Explain with example.
How do I delete a table in db2?
What is db2 connect?
What is the difference between db2 and oracle?
What is null indicator in db2?
What is buffer pool in the db2 database?
What is the maximum number of columns in a db2 table?
define clustering index.
can we view the access paths created by dbrm ? how ? thx
Is it possible using max on a char column?
What are iseries servers?
What is db2 instance?
List out the buffer pools in db2
What is syscat in db2?
