What is UNION,UNION ALL?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is innodb buffer pool?
What is the function of the Data Manager?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What is check constraint in db2?
What are the four lockable units for DB2?
What is db2 command?
Which isolation level provides maximum concurrency?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are the advantages of using a PACKAGE?
What is the difference between CS and RR isolation levels?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
List out the buffer pools in db2