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
Which Model uses the SET concept
What is model database? : SQL Server Architecture
Is it possible to call a stored procedure within a stored procedure?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Introduction of rollup clause using sum and group by clause?
What is the difference between dataadapter and datareader?
How do I view a stored procedure in sql server?
Tell me about the approaches which you used to counter the DI problems.
Write the SQL query to drop, truncate and delete table.
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Explain Reporting Life Cycle?
What are advantages of ssrs or why we should use ssrs?
Explain subquery and state its properties?
Explain the concept of view and Types of views in SQL server?
what's the information that can be stored inside a bit column? : Sql server database administration
