Union cont.

• Removes all duplicates by default.Using the ALL keyword prevents this.UNION ALL

• Can use an ORDER BY only in the last SELECT statement which applies to all the output

• Can eliminate the need to write numerous SELECT statements.

Previous slide

Back to first slide

View graphic version