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 >> SQL Server
  2. Suggest New Category

what is differece between union and union all

Question Posted / dinesh waitage

Answer Posted / dinesh waitage

1)Union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables.

2)UNION - returns on Distinct rows/Slower in performance
UNION ALL.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain primary key in sql server?

970

Some queries related to SQL

933

Can another user execute your local temporary stored procedures?

939

What is 3nf normalization form?

1023

Is sql server 2016 free?

884

Explain what is analysis service repository?

925

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

912

What is merge join?

1124

Does group by sort data?

845

How to create a simple stored procedure in ms sql server?

973

Write an sql query to find first weekday of the month?

863

What is difference between equi join and inner join?

857

What are the new data types are introduced in sql 2000?

858

How to set database to be single_user in ms sql server?

966

What is a functions and types in sql server?

1010