What is the difference between UNION and UNIONALL?
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
What are the events recorded in a transaction log?
What are the features of Embedded SQL
What are translations and its use? : sql server analysis services, ssas
Can a table be moved to different filegroup?
How do I make a resultset scrollable?
What is proper subset of candidate key?
How can we remove orphan records from a table?
Explain SSRS Architecture?
Which language rdl files made of?
What do you understand by a stored procedure?
How to delete multiple rows with one delete statement in ms sql server?
What are distributed partitioned views?
How to use transact-sql statements to access the database engine?
How do you create a clustered index?
Does an index slow down updates on indexed columns?