Interested to Buy Any Domain ? << Click Here >> for more details...
wht is d/f between union and joins ?
- 2 Answers
- 6520 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 |
Where is the output of EXPLAIN stored?
What is tablespace?
How can we retrieve the total number of records in RPG & CLLE?
What is read-only cursor?
What is the role of the data page in the db2 database?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
How is a typical DB2 batch program executed ?
How can you do the explain of a dynamic sql statement?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
List down the types of triggers in the db2 database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
