Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13711 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / suresh
UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What are the restrictions that views have to follow?
How do I view views in sql server?
What is forward - only cursors / read only cursor?
What is @@error in sql?
What are sql dirty pages?
How to download and install microsoft .net framework version 2.0?
What is an index in sql?
Can you force a query to use a specific index?
How to select an exiting database using mssql_select_db()?
What is difference between view and materialized view?
How to create an inline table-valued function?
what is raid? : Sql server database administration
What is a primary key?
what is database replication? : Sql server database administration
how to invoke a trigger on demand? : Sql server database administration
