wht is d/f between union and joins ?

Question Posted / visu.kanchamreddy

2 Answers
6253 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

What is ibm db2 database?

0 Answers

How to solved 818 error

4 Answers Keane India Ltd, Wipro,

what is the use of cursors?

3 Answers iGate,

What are data types?

2 Answers

How Plan is created while executing the query using SPUFI?

3 Answers

What is the SQL Communications Area and what are some of its key fields?

1 Answers

What are the 2 sqlcodes that are returned?

0 Answers

Can we able to find all the Table names under a Particular Plan?

1 Answers CTS,

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers Deloitte,

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers Accenture,

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers

For more DB2 Interview Questions Click Here