Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shyam
Union: It will combine the output of two or more queries &
it will eliminate duplicate values.
Union all:It will combine the output of two or more queries
& it will not eliminate duplicate values.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is cube dimension? : sql server analysis services, ssas
How to view existing indexes on an given table using sp_help?
What is difference between oltp and olap?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is an example of a foreign key?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How to add additional conditions in SQL?
List out the differences between the clustered index and non-clustered index in sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Tell me what is the significance of null value and why should we avoid permitting null values?
Please differentiate between a local and a global temporary table?
Can we use where and having clause together?
Explain the phases a transaction has to undergo?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is statement level trigger?
