A join selects columns from 2 or more tables. A union selects rows

What is the difference between join and union.

Question Posted / thangamadasamy

Answer Posted / thangamadasamy

A join selects columns from 2 or more tables. A union
selects rows

Is This Answer Correct ?

123 Yes

63 No

Please Help Members By Posting Answers For Below Questions

Why do we need view in sql?

1039

what is oracle database ? : Sql dba

1080

What are the possible values for the boolean data field?

1012

What is loop in pl sql?

1078

Is like operator in sql case sensitive?

1077

Show how functions and procedures are called in a pl/sql block.

1185

How to check if a column is nullable before setting to nullable?

1185

What is dml with example?

1155

What are transaction and its controls?

1089

What is rtm stands for?

1173

What is sql engine in oracle?

1040

What is a scalar value in sql?

1122

What is the purpose of the sql select top clause?

1205

What are aggregate functions in sql?

1225

What does t sql mean?

1002