What does the SQL INTERSECT operator return?

A Rows from the first SELECT that do not appear in the second B All rows from both SELECT statements including duplicates C Rows that appear in both result sets of two SELECT statements D Rows where column values intersect numerically