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 purescale?
Are view updateable?
What is a buffer in memory?
Explain the benefits you can get from mainframe connect?
How do I delete a column in db2?
What is null indicator in cobol db2?
What is db2 bind process?
What is schema in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is dbrm library?
How can we retrieve the total number of records in RPG & CLLE?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Can one database have multiple instances?
What is meant by dclgen?
What is runstats db2?
