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
- 15378 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
Differentiate between cs and rr isolation levels? Where do you specify them?
How would you find out the total number of rows in a db2 table?
What is a bind in db2?
What are the benefits of using the db2 database?
What is null indicator in cobol db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
List out the data types available.
What is the physical storage length of timestamp data type?
What is cascading rollback?
What is db2 purescale?
What os does db2 run on?
What is isolation level in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is difference between isnull and coalesce?
How connect db2 database to datastage?
