Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

what is the difference between UNION AND UNIONALL

Question Posted / krishna kant kumar

Answer Posted / krishna kant kumar

The UNION operator returns all rows from two or multiple tables and eliminates any duplicate rows but the UNION ALL operator returns from both queries, including all duplications.
The UNION operator can use DISTINCT keyword but the UNION ALL cannot it.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to invoke the data pump export utility?

1117

What is an oracle user role?

939

Why do we use bulk collect in oracle?

1012

How to create a temporary table in oracle?

1195

Can we write dml statement in function in oracle?

1026

What are the uses of Database Trigger ?

1625

How can Oracle users be audited?

1056

What is a read write transaction in oracle?

1032

How to empty your oracle recycle bin?

982

What is the difference between substr and instr?

980

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1811

How to define a sub function?

1084

Explain what does a control file contain?

1034

what is IDE,DMV in sql server?

2754

What is a nested table and how is it different from a normal table?

988