Last answered:

23 Dec 2021

Posted on:

15 Jul 2021


Union vs Union ALL Solution

Can someone please breakdown this solution.

1 answers ( 0 marked as helpful)
Posted on:

23 Dec 2021


Hi Osmiguel!

Thanks for reaching out.

Although the solution contains many lines of code, the idea is to "form" several result sets containing the same fields, and vertically combine them together.
More precisely, we have used as an alias for each result set, or each subset, a different letter (A, B, C, D). Then, we combine these subsets.

Hope this helps but please feel free to get back to us should you need further assistance. Thank you.

Submit an answer