union is used to retreive the data with out duplication union all is used

What is the difference between UNION and UNIONALL?

Question Posted / valarmathi

Answer Posted / valarmathi

union is used to retreive the data with out duplication
union all is used to retreive the data with duplication

Is This Answer Correct ?

18 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the steps to use transact-sql cursor?

1064

What is transaction server auto commit?

1066

How to create a login account in ms sql server to access the database engine using "create login" statements?

1146

State the difference between local and global temporary tables?

1119

can a table be moved to different filegroup? : Sql server administration

979

Explain indexed views?

986

What are the restrictions while creating batches in sql server?

1062

What is rtm version in sql server?

1055

How to change the password of a login name in ms sql server?

1013

What is the process of indexing?

1009

How does normalization work?

924

What is normalization and its types?

1036

What are the requirements on sql server network connections?

1000

If user is owning any SQL Objects, can we drop that user

2078

What stored procedure can you use to display the current processes?

894