> > >

Microsoft SQL Server MCQs

Consider the following queries: A: select * from [tbl1] union select * from [tbl2]; B: select * from [tbl1] union all select * from [tbl2]; What is the difference between these two queries?

Query A will return both full result sets; Query B will return both result sets with duplicates removed.

Query A and B return the same result set.

Query A will return both result sets with duplicates removed; Query B will return both full result sets.

Answer

Correct Answer: Query A will return both result sets with duplicates removed; Query B will return both full result sets.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it