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 a dbrm in db2?
What is the syntax for creating a table in the db2 database?
What is dbrm library?
What is the use of predicate?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is coalesce in db2?
What is the purpose of using commit?
What is difference between rollback and commit?
How would you find out the total number of rows in a db2 table?
What is the physical storage length of timestamp data type?
What is null indicator in db2?
What is rebind in db2?
List down the data types in the db2 database.
How will you return the number of records in table?
What does db2 mean?
