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
How do I port a number to sql server?
Explain about thread and memory management process of SQL?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What sql server means?
What are subqueries in sql server?
what's the difference between a primary key and a unique key? : Sql server database administration
Explain the properties of sub-query in sql server?
Explain filestream storage of sql server 2008?
what are the new features introduced in sql server 2000? : Sql server database administration
How do I connect to sql server database?
What are the different types of collation sensitivity in sql server?
What is the importance of three tier architecture?
Define master database?
How to link tables in sql server?