INTERSECT to Find Common Records
Medium
set-operations
Oracle
Salesforce
Bloomberg
Write a query using INTERSECT to find customers who have made both online and in-store purchases. Return customer_id, ordered by customer_id.
Expected Output: Customer IDs appearing in both channels.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...