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
Define full outer join in sql server joins?
Can we create clustered index on composite key?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is key set driven?
What is clustered primary key?
Can a trigger be created on a view?
Where sql server usernames and passwords are stored in a sql server?
How do I completely remove sql server instance?
Can an automatic recovery be initiated by a user?
Is it possible to update the views? If yes, how, if not, why?
What is a group function explain with an example?
What happens if null values are involved in boolean operations?
What is efficiency data?
How to sort the query output with order by clauses in ms sql server?
