Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14134 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
Explain Capacity planning to create a database? and how to monitor it?
Give me any three differences between Truncate and Delete.
Introduction of rollup clause using sum and group by clause?
What is meant by dirty read?
What stored by the master?
What is the difference between dataadapter and datareader?
What is a join in sql? What are the types of joins?
What is optimistic concurrency?
Which is the main third-party tool used in sql server?
What is the difference between coalesce() & isnull()?
What is merge join?
How do you trace the traffic hitting a sql server?
What is the use of partition by in sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is db stored procedure?
