Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dinesh waitage
1)Union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables.
2)UNION - returns on Distinct rows/Slower in performance
UNION ALL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are basics of policy management?
Explain logical operators in sql server?
How does the report manager work in SSRS?
What is query processing?
What's new in sql management studio for sql server? : sql server management studio
Tell me what are cursors and when they are useful?
What do you mean by tablesample?
Can you create a logon trigger in sql server 2005 express edition?
Explain about remote stored procedure?
What are different types of statements that are supported by sql?
How to write character string constants or literals in ms sql server?
How can we migrate from SQL server to SQL Azure?
Difference between Sql server reporting services and Crystal reports?
what are acid properties? : Sql server database administration
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
