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 are pl/sql packages?

1087

explain the difference between delete , truncate and drop commands? : Sql dba

1074

What are the features of pl sql?

1054

What are the advantages of normalization?

1070

how many sql dml commands are supported by 'mysql'? : Sql dba

1099

What is a system versioned table?

964

When is a declare statement required?

1130

Explain the steps needed to create the scheduled job?

1028

What is substitution variable?

1034

Explain sql data types?

1078

What does the argument [or replace] do?

1068

What is lookup table in sql?

1024

What is the best partition size for windows 10?

989

Write an sql query to select all records from the table?

1000

Can you do multiple joins in sql?

1023