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
How do I add a column to a table in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the use of db2?
What type of database is db2?
Where can you declare a cursor in a cobol-db2 program?
What is check constraint. Explain with example.
Explain about rct in db2?
How is the value function used?
What is rct?
Is db2 a database?
Can one database have multiple instances?
Why select is not preferred in embedded sql programs?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How to check last update on table in db2?
