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 are the important architecture components of SSRS?
What do you understand by replication in sql server?
How to check parameter value in stored procedure sql server?
What is sql view?
Explain different types of Normalization.
Explain ranking functions?
Tell me what is log shipping?
What objects does the fn_my_permissions function reports on? : sql server security
Can group functions be used in the order by clause in ms sql server?
what is bit datatype? : Sql server database administration
Which tcl commands are available on the sql server?
What are built in functions?
Determine when an index is appropriate?
How do I find query history in sql server?
What are different types of replication in sql server?