UNION provides only distinct values as output whereas UNION ALL provides

what is the difference between UNION AND UNIONALL

Question Posted / k

Answer Posted / k

UNION provides only distinct values as output whereas UNION
ALL provides all values.
So UNION ALL seems to be faster than UNION.

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is hash cluster in oracle?

1244

What are the uses of synonyms?

1183

What would you do with an in-doubt distributed transaction?

2044

Explain integrity constraints?

1157

Explain the use of full option in exp command.

1175

How view is different from a table?

1081

What are the limitations of check constraint?

1073

What is data file?

1149

How to list all indexes in your schema?

1140

When do I need to use a semicolon vs a slash in oracle sql?

1141

Explain temporal data types in oracle

1133

what is meant by magic query

2230

Explain oracle’s system global area (sga).

1186

How to insert a record into a table?

1120

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1975