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

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

159

What is delete query?

994

What stored by the master?

1014

Explain linked server in sql?

1296

What new data source types were added in ssrs 2014?

169

If a stored procedure is taking a table data type, how it looks?

6526

How can you check the version of sql server?

1164

Does sql server use java?

1127

What is ms sql server service broker?

1048

How to enter comments in transact-sql statements?

991

Mention the command used to rename the database.

1055

What is 'write-ahead log' in sql server 2000 ?

1110

Why de-normalization required?

1055

Explain foreign key in sql server?

1075

What authentication modes does sql server support?

1155