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

Is foreign key mandatory?

558

What is sql partition?

556

What are stuff and replace function?

575

How to pronounce postgresql?

584

What is sql basics?

586

Why is nosql good?

599

What is a sql instance vs database?

581

What are pl/sql cursor exceptions?

577

How do I view stored procedures?

545

What is the difference between syntax error and runtime error?

615

Is like operator in sql case sensitive?

510

Why is a primary key important?

547

Is sql better than access?

546

Why do we need pl sql?

550

What is rename command in sql?

468