如何获得结果集的交集？

SELECT column1, column2, ...
FROM table1
INTERSECT
SELECT column1, column2, ...
FROM table2;

list1 = [1, 2, 3, 4, 5]
list2 = [4, 5, 6, 7, 8]

intersection = set(list1) & set(list2)
print(intersection)  # 输出: {4, 5}

import java.util.*;

public class IntersectionExample {
    public static void main(String[] args) {
        List<Integer> list1 = Arrays.asList(1, 2, 3, 4, 5);
        List<Integer> list2 = Arrays.asList(4, 5, 6, 7, 8);

        List<Integer> intersection = new ArrayList<>(list1);
        intersection.retainAll(list2);

        System.out.println(intersection);  // 输出: [4, 5]
    }
}

const array1 = [1, 2, 3, 4, 5];
const array2 = [4, 5, 6, 7, 8];

const intersection = array1.filter(value => array2.includes(value));
console.log(intersection);  // 输出: [4, 5]