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 are the advantages of user-defined functions over stored procedures in sql server?
What triggers long term care?
Explain in brief about Microsoft SQL server?
What is the difference between cartesian product and cross join?
What is transact-sql ddl trigger?
Explain user defined views?
What is the maximum size per database for sql server express?
What are user defined functions in ms sql server?
What are the differences between ms sql server & oracle?
Explain different forms of normalization?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is the difference between executequery () and executeupdate ()?
what is sql server? : Sql server database administration
What are distinctive joins find as a part of sql?
What is view in sql?
