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

Can the query output be sorted by multiple columns in oracle?

971

Explain integrity constraint?

1142

Explain self joins in oracle?

995

How to execute a stored program unit?

1049

How do I escape a reserved word in oracle?

1185

What is the data pump export utility?

1061

How to drop a stored function?

1125

how to handle exceptions in post production

1404

What is data block in Oracle?

1088

How to export data to a csv file?

1273

How to speed up webrick?

1058

What do you understand by database schema and what does it hold?

1221

What are the differences between char and nchar in oracle?

1066

What are the restrictions in a oracle read only transaction?

1007

How to shutdown your 10g xe server from command line?

1066