In Join, matching rows are joined side-by-side to make the result table b

What is the difference between join and union.

Question Posted / vijay kulkarni

27 Answers
181317 Views
3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
E-Mail Answers

Answer Posted / vijay kulkarni

In Join, matching rows are joined side-by-side to make the
result table but whereas in Union rows are joined one-below
the other to make the result table.

Is This Answer Correct ?

21 Yes

33 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention what does the hierarchical profiler does?

1140

What is the primary key?

1002

Is left join faster than join?

1096

What is partition by in sql?

1127

What is sql constant?

1104

How do I order columns in sql?

1073

How to know the last executed procedure?

1156

Explain ttitle and btitle.

1165

Does truncate free space?

1064

What are system versioned tables?

1074

What is the difference between microsoft sql and mysql?

1017

Is merge a dml statement?

1029

What are triggers in sql?

1061

Can a key be both primary and foreign?

1055

Can we call dml statement in function?

1099