Oracle SQL,PL/SQL

Difference between union and union all?

Written by shohal

Union and Union all

The only difference between Union and Union All is that Union removes duplicate record and Union All will not removes duplicate rows or records.

About the author

shohal

Leave a Comment