wht is d/f between union and joins ?

Question Posted / visu.kanchamreddy

2 Answers
6247 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

wht is d/f between union and joins ?..

Answer / lu

union for the row...
joins for a column...

Is This Answer Correct ?

6 Yes

2 No

wht is d/f between union and joins ?..

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

Post New Answer

More DB2 Interview Questions

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers UST,

what is the role of the cursor in db2?

0 Answers

How does DB2 use multiple table indexes?

1 Answers

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers Infosys,

what is the name of the default db2 catalog database?

3 Answers IBM,

how can u understand the end of the table ?

1 Answers TCS,

When would you prefer to use VARCHAR?

3 Answers

What is a db2 collection?

0 Answers

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers IBM,

Explain about rct in db2?