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
Is ibm db2 open source?
What is the result of open cursor statement?
What is null indicator in db2?
Highlight all the advantages that are attached to a package.
Which isolation level provides highest data integrity?
Explain about dbrm.
How can you classify the locks in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the 2 sqlcodes that are returned?
What is dbrm? What it contains?
How can the duplicate values be eliminated from db2 select?
What is the max length of sqlca?
How to restart a DB2 program?
How do I import a csv file into db2?
is it compulsory commitment control in journal?
