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

Explain how exception handling is done in advance pl/sql?

954

What is the difference between partitioning and sharding?

946

what is the difference between group by and order by in sql? : Sql dba

1049

What is difference between inner join and self join?

1028

how to load data files into tables with 'mysqlimport'? : Sql dba

1031

What are the operators in sql?

969

How to pipe multiline string to isql?

958

What are transaction and its controls?

967

What is query execution plan in sql?

1124

How many commands are there in sql?

970

Why is pl sql needed?

871

Why do we use triggers?

913

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

941

What if we write return in procedure?

1331

Why we use joins in sql?

924