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
How to test a dml trigger in ms sql server?
What's new in sql management studio for sql server? : sql server management studio
How would you add a section to a table?
What is a transact-sql statement?
How do you migrate data from mssql server to azure?
What is Service Broker in sql server 2012?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
is there a column to which a default can't be bound? : Sql server database administration
Disadvantages of the indexes?
What is sqlservr.exe - process - sql server (sqlex?press)?
What is CTE in SQL
What is an etl file?
How to scale out a federation by Sql statement?
What is the difference between DataRow.Delete() and DataRow.Remove()?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
