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

What is forward - only cursors / read only cursor?

1101

What is failover clustering overview?

1100

What is a Join and explain its types?

1110

Difference between Sql server reporting services and Crystal reports?

172

How to create a local temporary stored procedure?

1005

What is the purpose of data source?

1055

How to automatically create a log when an exception is being received into SQL Server?

1302

What is an example of a primary key?

998

What are the types of lock supported by ?

1055

What is 2nf example?

1003

What are “phantom rows”?

1670

Do you know how to send email from database?

1017

What is Replication?

1059

What is the stuff and how does it differ from the replace function?

1145

What is the purpose of indexing?

1053