The UNION removing any dups here is what makes them the same - the top query would never have duplicates as written.
RobertTableaux
joined 1 year ago
To answer the question asked, yes, these will “out the same data”. Anyone telling you they’re not the same isn’t looking at what you care about being the same - the rows output (regardless of order). From that perspective, and disregarding performance (as you also mentioned in your question) these queries will give you the same results.
Elaborate and explain
See what is happening in the world right now.
Used to. And no, I didn’t move.
Perfect - thank you!
My day has come!!!