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...

What is difference between Union and Union All ?

Answer Posted / sagar

1) By union ALL u will get duplicate records also(the records common between 2 tables 2 times) but Union gives u union of 2 tables
2) 'Union All' is faster than Union

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the Roles in mstr?

1027


Explain rw document?

1153


what do you mean by passthrough functions?

1017


How do you ensure simultaneous releases across multiple operating systems?

1018


What is the conflict resolution window?

1118


What is the difference in the way microstrategy handles custom group and consolidations?

1041


What is fact extension?

1202


You have got the requirement from a client. Explain the technical approach you will take now.

1032


what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

993


What is derived metric?

1030


hi,can you please share with me about,what is reportlimit,report order and how can create and use

5329


suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

1027


Explain system call error?

1060


Your application mode has crashed. How would you get the instance back?

1002


Explain factless facts?

1025