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 primary key?

898

what is the difference between Tabular and Matrix report?

160

How can you ensure that the database and sql server based application perform well?

1013

What is nolock?

927

How to create a view on an existing table in ms sql server?

1052

What is the use of group by clause?

899

What are extended events in sql server?

903

Mention the uses of stored procedures.

927

What does it mean if @@cursor_row returns a negative number?

941

How do you start single user mode in clustered installations?

901

what is bit datatype? : Sql server database administration

864

What is the purpose of optimization?

950

Can group by and orderby be used together?

963

what are candidate key, alternate key and composite key? : Sql server database administration

852

What does asynchronous call backs means?

1071