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 join and name different type of joins?
How can we determine what objects a user-defined function depends upon?
How many triggers are possible per table?
What is a select query statement in ms sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is the fillfactor concept in indexes?
What is SQL Azure Firewall?
How do I find the size of a sql server database?
In what three ways is the return statement used in a stored procedure?
What is database replication?
What is bulkcopy in sql?
What are the differences between sql server and mysql.
What is the security model used in sql server 2005?
What is mean by candidate key?
What are dml (data manipulation language) statements in ms sql server?