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 differece between union and union all

Answer Posted / ramesh raja

UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does index slows down insert statements?

984


Which database stores information about replication?

1036


How to enter date and time literals in ms sql server?

991


What are logical/boolean operations in ms sql server?

1016


Why transaction is important?

963


Why people hate cursor?

1129


What happens if null values are involved in datetime operations?

956


Explain contrast amongst grouped and non-bunched records?

1006


What are the dmvs?

999


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1837


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1081


Explain system views?

1067


Explain what is lock escalation and what is its purpose?

918


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1147


How to create a user to access a database in ms sql server using "create user" statements?

937