Answer: INTERSECT

To understand the correct answer, let's break down the options: - **UNION ALL** – Retrieves all rows, including duplicates, from both queries. - **UNION** – Retrieves distinct records from both queries, removing duplicates. - **MINUS or EXCEPT** – Retrieves rows from the first `SELECT` statement not found in the second `SELECT` statement. - **INTERSECT** – Retrieves only the rows common to both `SELECT` statements. - **COPY INTO** – Offers an idempotent method for incrementally ingesting data from external systems, with expectations like consistent data schema and handling of duplicate records downstream. The correct command to find common records is **INTERSECT**.

Author: LeetQuiz Editorial Team