Recently I was reviewing the code in one of the projects and came across a query in which multiple record sets (SELECT Statements) were combined using an UNION operator. I noticed another thing that in the individual SELECT statements, a DISTINCT clause...