Explain union,minus,union all,intersect?
Posted by silpa on Sep 17 2007
intersect returns all distinct rows selected by both queries
minus selects distinct rows selected by first query but not the second
union returns all distinct rows selected by either query
union all returns all rows selected by either query including duplicates
Leave a Comment