INTERSECT

SQL Optimizer for IBM DB2 z/OS

INTERSECT

Denotes the INTERSECT operation.

This node returns rows in both the inner and outer tables and eliminates redundant duplicate rows.