what is the difference between join and union?
Answer Posted / ananda kumar
join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
List down the types of triggers in the db2 database?
is it compulsory commitment control in journal?
What is coalesce in db2?
What is the role of union all and union
What does reorg do in db2?
What does db2 plan contain?
What is meant by union and union all?
Explain about mirror activator disk mirroring?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
List out the buffer pools in db2
Explain db2.
What is a dbrm in db2?
Which components manage deadlocks in db2?
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 does runstats do in db2?