Code Pumpkin

Tag Archives: Set Operators

UNION Vs UNION ALL | Oracle SQL

May 28, 2017
Posted by Abhi Andhariya

Though both UNION and UNION ALL is used to combine results of two SELECT queries, the main difference between them is that UNION doesn't include duplicate records, but UNION ALL does. Another difference between them is that UNION ​ALL is faster than UNION , but may look slow because it returns more data which takes more […]

Total Posts : 124
follow us in feedly

Like Us On Facebook