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
How self join is different from outer join?
What is RAID? What are the different types of RAID configurations?
how can you check the level of fragmentation on a table? : Sql server administration
Why I have to use stored procedures?
Can you explain about buffer cash and log cache in sql server?
Why normalization is used?
How to manipulate data from one table to another table ?
What are the advantages to use stored procedures?
What types of replication are supported in sql server?
How to execute stored procedure in select statement sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is executereader?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the difference between grant and with grant while giving permissions to the user?