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

What are functions in sql?

936

What is the starting oracle error number? What is meant by forward declaration in functions?

971

Why do we use view in sql?

932

How to Declare Fixed Length String Value In PL SQL

1135

Can triggers stop a dml statement from executing on a table?

1066

what is the bond code in materialized view?

2981

how to shutdown mysql server? : Sql dba

1077

what is the difference between truncate and drop statements? : Sql dba

1095

What is pl sql and why it is used for?

1098

How do I create a sql database?

978

How insert into statements in sql?

1056

What is the difference between nvl function, ifnull function, and isnull function?

1086

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1144

What is meant by truncate in sql?

1045

What is t sql used for?

1003