Last answered:

23 Dec 2021

Posted on:

15 Jul 2021

0

Union vs Union ALL Solution

Can someone please breakdown this solution.

1 answers ( 0 marked as helpful)
Instructor
Posted on:

23 Dec 2021

0

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.
Best,
Martin

Submit an answer