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

Can instead of triggers be used to fire once for each statement on a view?

1006

Which is faster count (*) or count 1?

1088

What is compilation error in pl sql?

1025

What is raid? How does it help storage of databases?

1133

What is trigger and stored procedure in sql?

1093

What is the difference between the implicit and explicit cursors?

1111

How to place comments in pl/sql?

1216

What do you understand by pl/sql cursors?

1148

What is server name sql?

1204

Can variables be used in sql statements?

1074

How many sectors are in a partition?

1118

In what condition is it good to disable a trigger?

1071

What is trigger types in sql?

1044

What is the maximum number of triggers, you can apply on a single table?

1048

How to change the order of columns in Oracle SQL Plus ?

1102