Returns a list containing the distinct elements that are present in both list1 and list2.
See also
Other list:
array_extract(),
array_length(),
concat(),
contains(),
flatten(),
generate_series(),
len(),
list_aggregate(),
list_concat(),
list_contains(),
list_cosine_distance(),
list_cosine_similarity(),
list_distance(),
list_distinct(),
list_extract(),
list_filter(),
list_grade_up(),
list_has_all(),
list_has_any(),
list_inner_product(),
list_negative_inner_product(),
list_position(),
list_reduce(),
list_resize(),
list_reverse_sort(),
list_select(),
list_slice(),
list_sort(),
list_transform(),
list_unique(),
list_value(),
list_where(),
list_zip(),
or–or,
range(),
repeat(),
unpivot_list()