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 risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How do I find query history in sql server?
What is sql or structured query language?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How do I start sql server 2017?
What is the difference between for xml raw and for xml auto?
Explain “row_number()” in sql server with an example?
What is normalization and what are the advantages of it?
How do I find the sql server version?
How can you append an identity column to a temporary table?
Can we do dml on views?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a scheduled job or what is a scheduled task?
What are wait types?
