Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to insert stored procedure result into temporary table?
How to start and end transact-sql statements?
What is the usage of the sign function?
What are different types of subquery?
Suggest a method of joining two tables.
What is a rownum?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is a Join and explain its types?
What is join query?
How is table type constraint applied to a table?
What are subqueries in sql server?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What does indexation mean?
What is self contained scalar sub query?
Explain primary key in sql server?
