Interested to Buy Any Domain ? << Click Here >> for more details...
wht is d/f between union and joins ?
- 2 Answers
- 6354 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amarnath reddy
use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;
use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;
| Is This Answer Correct ? | 4 Yes | 1 No |
Describe major components of db2?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
How to connect to db2 database from windows command line?
What is the FREE command?
Explain the contention situations caused by locks?
what is plan? is plan executable or package?
What is meant by union and union all?
What is index cardinality?
What os does db2 run on?
How to take backup of table in db2?
what are extents?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
COBOL 
