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 stored by the msdb?
What is a not null constraint?
What is an index in sql?
what is an index? : Sql server database administration
What are diverse clauses that form a part of sql?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is the sql case statement used for? Explain with an example?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What are the different type of replication in sql server?
What happens if the update subquery returns multiple rows in ms sql server?
Explain the various types of concurrency problem?
How to use group functions in the select clause in ms sql server?
What is isnull() operator?
Difference between aggregate functions of sql?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?