What is the difference between UNION and UNIONALL?
- 5 Answers
- 12632 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
Define outer join?
Find nth lowest salary or get nth lowest salary?
What are the elements of dbms?
How do I create an extended event in sql server?
What is history table in sql server?
What are the properties of primary key?
How can I tell if sql server is 32 or 64 bit?
How to create nested stored procedure?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What can be used instead of trigger?
What is nonclustered index with included columns ?
How to drop an existing table?
What is ems sql management studio? : sql server management studio
What is transact-sql language?
