What is the difference between UNION and UNIONALL?
Answer Posted / valarmathi
union is used to retreive the data with out duplication
union all is used to retreive the data with duplication
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What does ss stand for sexually?
Describe the left outer join & right outer join. : sql server database administration
What are the extra roles available in msdb? : sql server security
How to execute a stored procedure in ms sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to find the service pack installed? : sql server database administration
What is the difference between Stored Procedures and triggers?
What is spid in sql server profiler?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What are differences in between sql server 2012 and sql server 2016?
Show Practically Sql Server Views are updatable?
What is b tree index?
How is sql used in sql server?
Which are ddl commands?
How many partitions a clustered index has by default in sql server 2012?