wht is d/f between union and joins ?
- 2 Answers
- 5678 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 |
How do you filter out the rows retrieved from a Db2 table ?
In terms of DB2 indexing, what is the root page?
What is an alias?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
how to fetch first 100 rows in db2
What is the purpose of rollback and commit?
What is collection in db2 bind?
Why do we bind in db2?
What is an instance database?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What's The Error Code For Unique Index Voilation?
What is db2 plan table?
COBOL 
