A UNION statement eliminates duplicate rows; A UNION ALL statement include

what is the difference between union and union all

Question Posted / ajith

Answer Posted / ajith

A UNION statement eliminates duplicate rows;
A UNION ALL statement includes duplicate rows.

Is This Answer Correct ?

37 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How do you run a query?

593

How many clustered indexes can be created on a table?

599

How can I speed up sql query?

536

Can we join 3 tables in sql?

506

Why self join is used in sql?

510

Can we write ddl statements in functions?

575

What are the different types of functions in sql?

521

What is before and after trigger?

529

What is a data definition language?

564

What is nvarchar max in sql?

590

What does pl sql stand for?

665

Does sql use python?

575

What are the string functions in sql?

536

What is pivot table in sql?

529

What is the importance of sqlcode and sqlerrm?

864