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
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Why use “in” clause in sql server?
We need to perform what steps in the following order to work with a cursor?
What were the latest updates to SQL Azure service?
What is difference between equi join and inner join?
Explain the concept of recursive stored procedure.
Why the trigger fires multiple times in single login?
What is a Join and explain its types?
What is merge replication?
What is difference between index and primary key?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Can you explain about buffer cash and log cache in sql server?
What are cursors stored procedures and triggers?
How to choose all records from the table?
How to update values in a table with update statements in ms sql server?
