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 / samy

Answer Posted / samy

Union:
combine two tables and common values to be retrieved no
duplicate values

Union All:

All the values to be retrieved when combine two table.
(duplicate values)

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1079

What are the types of indexing?

1117

What is the index requirement in SQL Azure?

98

What is the osql utility?

1037

Mention the uses of stored procedures.

1008

How to execute a sql statement using odbc_exec()?

1219

How do you trace the traffic hitting a sql server?

1192

Explain transaction isolation levels in sql server?

1184

What is a data source or ds? : sql server analysis services, ssas

1052

What is an etl file?

1008

What is implicit cursors?

1133

What is the purpose of a table?

995

What is Transparent Data Encryption?

1061

What are the types of subscriptions in SQL Server replication?

1104

Can we call stored procedure in trigger?

998