What is the difference between UNION and UNIONALL?
- 5 Answers
- 12634 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
union is used to retreive the data with out duplication
union all is used to retreive the data with duplication
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How to update a field in SQL after ALTERING a row?
What is a full text index?
Working with TLogs
What are the different authentication modes in sql server? How can it be changed?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are indexes in sql?
What is etl - extraction, transformation, and loading?
How to find the source of a table in sql server?
What is self contained scalar sub query?
What is the cartesian product of table?
How to recompile stored procedure at run time?
Which is better statement or preparedstatement?
What are the two modes of authentication in sql server?
What is cross join in sql server joins?
What is cdc in sql server?
