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

Compare microstrategy and tableau.

911


What do you mean by inmon?

1013


What is microstrategy intelligence server?

972


Explain security filter?

938


Can reports be executed in off-peak periods?

936


What is the difference between absolute filtering and standard filtering in microstrategy?

914


Explain true primary keys?

934


What is fact degradation?

914


you are required to disable webusers to use only one i-server. How would you do that?

837


Explain confirmed dimensions. When are they used?

928


Write the different types of matrices in microstrategy?

911


What is a joint child?

889


What are objects?

944


How do users receive only information that they want?

925


Explain fact relation?

929