Another difference is that union will sort the result sets whereas union

what is the difference between union and union all

Question Posted / srinivas

Answer Posted / srinivas

Another difference is that union will sort the result sets
whereas union all will not.

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is inner join in sql?

1023

How do you modify a table in sql?

1082

What are sql functions? Describe in brief different types of sql functions?

1043

What is the difference between the implicit and explicit cursors?

1010

how to fetch alternate records from a table? : Sql dba

1072

What is crud stand for?

956

What is pl sql script?

993

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2438

How many types of primary keys are there?

999

What does inner join mean?

1097

Why query optimization is needed?

885

What are procedures used for?

938

How do you write a complex sql query?

1030

How many subqueries can be nested in a statement?

951

What is cursor and why it is required?

1132