What is the difference between UNION and UNIONALL?
Answer Posted / amit dixit
Just Above is OK except UNION ALL result modified..
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
Result Set:
UNION: First,Second,Third,Fourth,Fifth,Sixth (This will
remove duplicate values)
UNION ALL:
First,First,Second,Second,Third,Fourth,Fifth,Fifth,Sixth
(This will repeat values)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is msdb database? : SQL Server Architecture
How can you find out how many rows returned in a cursor?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is wide table?
What is database dimension? : sql server analysis services, ssas
What are the advantages to use stored procedures?
What is the simplest way to create a new database in ms sql server?
What is BCP? When does it used in sql server 2012?
What is b tree index?
How to write a query with a right outer join in ms sql server?
How to use column default values in insert statements in ms sql server?
What are the requirements on sql server network connections?
What is the function of sql server agent windows service?
What are the five major components of a dbms?
What happens if the update subquery returns multiple rows in ms sql server?