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 secondary key?

988

Does sql profiler affect performance?

1048

Does asenumerable execute the query?

1097

What is flag in sql?

1099

Explain the purpose of %type and %rowtype data types?

976

How to run pl/sql statements in sql*plus?

1146

Explain exception handling in pl/sql?

1083

How do I delete a trigger?

1015

what are date and time data types? : Sql dba

1028

How much ram can sql express use?

1041

What does seeding a database mean?

1023

what is oltp (online transaction processing)? : Sql dba

1129

What are stored procedures used for?

1052

What is sql mysql pl sql oracle?

1129

Is sql open source?

1025