Interested to Buy Any Domain ? << Click Here >> for more details...
What technique is used to retrieve data from more than one
table in a single SQL statement?
- 9 Answers
- 15774 Views
- CTS, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / mani
Both UNION or UNION ALL and JOIN can be used.
The purpose of retreiving data from more than one table in a
single statement generally happens when the ouput of the
involved tables has same table structure and in this case
either UNION (to eliminate the duplicates in the resultant
table)or UNION ALL (to retain the duplicates in the
resultant table)could be used.
If retrieval is based on seletion criterion then JOINS could
also be used but here the resultant table structure can be
different from that of the tables involved in join operation.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the function done by data manager?
What is check constraint in db2?
What is image copy in db2?
How do you pull up a query which was previously saved in qmf?
What is db2? Explain.
Is schema the same as database?
How do I add a column to an existing table in db2?
What are the contents of dclgen?
What is the use of with ur in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is reorg and runstats in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Where can you declare a cursor in a cobol-db2 program?
i want to maintain uniqueness on pdf without make lf??????????
What is the difference between plan and package in db2?
