Answer Posted / shabanafazal
in case of 'union' the data of two tables are combined
together with no repetition where as incase of 'union all'
repetition of data is done e.g in table 'A' we have name
saad three times and in 'B' table name 'ssad' is present
one time then in case of 'union' 'saad' is appeard once
(when union of table 'A' and 'B' is done). where as in case
of 'union all' the name 'saad' will repeated four times.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the boxing and unboxing concept in .net?
How do I save a stored procedure in sql server?
Can you explain different types of locks in sql server?
What is function of CUBE ?
Which is the main third-party tool used in sql server?
What is the parse query button used for?
What are sparse columns?
How to find out the list schema name and table name for the database?
What is unpivot?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Define left outer join?
explain the storage models of olap? : Sql server database administration
How does index makes search faster?
What stored by the model?
Do you know spatial data types - geometry and geography in sql server 2008?
