Hi all

can u explain the set operator in sort formmm..................


Thanks

Set operators are used to combine information of similar type from one or more tables.

Set Operators - UNION, UNION ALL , INTERSECT and MINUS

Minus :- Rows unique for the first query will be returned.

Intersect :- It returns common rows from different select statements

Union :- Union returns all the rows from two different select statements and then eliminate duplicate rows from the result set.

Union All :- Union all returns all the rows from two different select statements without eliminating duplicate rows.