union displays only different values in the multiple table. but union all

what is the difference between UNION AND UNIONALL

Question Posted / vaithianathan

Answer Posted / vaithianathan

union displays only different values in the multiple table.
but union all displays all related values.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is bulk collect in oracle?

997

What is meant by an index?

1145

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1918

What is data file?

1107

How do I connect to oracle database?

1119

Difference between pre-select and pre-query

1114

what is insert all statement in sql

6520

How to set up autotrace for a user account?

1059

what is the difference between data migration and production migration.

2346

How to use in conditions in oracle?

1058

How to use existing values in update statements using oracle?

1067

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

What happens to indexes if you drop a table?

1171

How to view the data files in the current database?

1098

Differentiate between post-database commit and post-form commit?

1048