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
What is thr feature of change data capture?
What is report snapshot?
What are the different types of cursor?
What is relationship? What number of sorts of relationship are there?
what is difference between view and Dip.
what kind of lan types do you know? : Sql server database administration
Explain trigger and its types?
What are different types of collation sensitivity?
Which table keeps information about stored procedures?
Name few endpoints exposed by ssrs 2012?
How to optimize stored procedures in sql server?
What is the difference between join and inner join?
What is sqlservr.exe - process - sql server (sqlex?press)?
Can you explain full-text query in sql server?
What are diverse clauses that form a part of sql?
