INTERSECT From SQL Optimizer for IBM DB2 z/OS previous page next page INTERSECT Denotes the INTERSECT operation. This node returns rows in both the inner and outer tables and eliminates redundant duplicate rows. previous page start next page