The results of INTERSECT are the same as INTERSECT ALL, except that when using INTERSECT, duplicate rows are eliminated before the intersection between the result sets is computed.

• INTERSECT的结果和INTERSECT ALL相同,只是在使用INTERSECT时,重复的行在计算结果集的交集之前已被排除。