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 meant by explain?
What is buffer pool and list some of them?
What is access path in db2?
What is meant by union and union all?
What is difference between isnull and coalesce?
What is database alias db2?
What is the picture clause of null indicator variable?
What is sqlca?
Can one database have multiple instances?
What is db2 look?
How to check last update on table in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is the default page size of buffer pools?
What type of database is db2?
What is dclgen in db2?
