Union v/s Union All
Often many ask, what is the difference between union and union all? Union operator combines multiple resultsets into one resultset. Union also removes the duplicates and returns a sorted result set. Union All operator combine multiple resultsets into one resultset, but it does not eliminate the duplicate rows. Since the duplicate… Continue Reading Union v/s Union All