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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What do you mean by rollback?
What is innodb buffer pool?
What is the function of logging in the db2 database?
What is an instance in db2?
What is the physical storage length of date data type?
What is the use of reorg in db2?
B37 abend during spufi?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the reason behind not using select * in embedded sql programs?
List down the types of triggers in the db2 database?
What does sqlcabc has?
What is the purpose of rollback and commit?
What is database reorganization?
What are db2 tables?
