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

How to use select statement to count the number of rows in oracle?

1048

What is tns entry?

1162

Point the difference between translate and replace?

1096

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2401

What is max rowid in oracle?

1026

Does oracle partitioning improve performance?

1004

Explain the use of indexes option in exp command.

1153

How to convert a string to a date in oracle database?

1057

Explain about functional dependency and its relation with table design?

1017

What is an index associated with a constraint?

1040

Explain mutating triggers.

1034

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1994

How to do paging with oracle?

1004

Explain table?

1121

What are the general rules on data consistency?

1012