Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is blu acceleration in db2?
Explain package in db2 and its advantages?
What is the maximum size of varchar data type in db2?
Mention the various locks that are available in db2.
What are the contents of a dclmgen?
What does runstats do in db2?
Is ibm db2 open source?
What is database reorganization?
What do you mean by commit and rollback?
what is utility for parm lib
How to compare data between two tables in db2?
Is schema the same as database?
Why select is not preferred in embedded sql programs?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is a plan and package in db2?
