UNION: combine distinct values between two tables UNION ALL : combine all

what is differece between union and union all

Question Posted / ramesh raja

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

Please Help Members By Posting Answers For Below Questions

Is sql different from sql server?

999

What is the maximum size of column in sql server?

845

List the different normalization forms?

928

List all the types of user-defined functions?

991

Give main differences between "Truncate" and "Delete".

1032

What is nonclustered index on computed columns?

905

What are the different types of join?

1100

How do I find the sql server version?

956

Can a table have 2 foreign keys?

856

What is implicit cursors?

1002

What is the difference between upgrade and migration in sql server?

1024

Explain activity monitors

1004

How can we improve performance by using SQL Server profiler?

984

When multiple after triggers are attached to sql table, how to control the order of execution?

977

What is the main difference between ‘between’ and ‘in’ condition operators?

1103