Union is used to combining the data with out duplication and effectively i

What is the difference between UNION and UNIONALL?

Question Posted / subramanya gv

5 Answers
13944 Views
CarrizalSoft Technologies, CTS, I also Faced
E-Mail Answers

Answer Posted / subramanya gv

Union is used to combining the data with out duplication and
effectively it is faster.
Union all is used to combining the data with duplication so
comparatively it is slower.

Is This Answer Correct ?

5 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is data source document?

1041

What are the benefits of normalization?

1109

What is an indexing strategy?

1010

What is triggers and its types?

1009

Define self join?

1029

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1213

What is difference between index and primary key?

1100

What is difference between sql and sql server?

1001

What are the advantages of using cte?

1015

What is the full form of ddl?

926

Explain datetimeoffset data type in sal server 2008?

908

Explain about system database?

1063

How dts is used to extract, transform and consolidate data?

1073

What is normalization 1nf 2nf 3nf?

1060

Can sql server be linked with other servers like oracle?

965