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 is a linked server in sql server?
How to count duplicated values in a column in ms sql server?
How to connect sql server management studio express to sql server 2005 express?
Explain cursor as data base object?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How to see existing views in ms sql server?
What is sql view?
Define right outer join in sql server joins?
what is denormalization and when would you go for it? : Sql server database administration
Where are SQL server users names and passwords are stored in sql server?
How to list all login names on the ms sql server?
What is the maximum size of sql server database?
How many types of subqueries are there in sql server?
can any body tell me how to know the password of current user in sql server
How to count groups returned with the group by clause in ms sql server?
