> Home > Scripts > SQL

 

Example of an intersect:

 

This cursor is used when you want to fetch data that exists in both subsets of data. 

 

 

(

  SELECT NAME

   FROM CUSTOMER_ADDRESS

)

INTERSECT

(

  SELECT NAME

  FROM CUSTOMER_SERVICE_LOCATION

)

;