How to filter repeated values in bigquery using AND condition
for example
I would like to select values from column A when column B has both 11 and 22
The below query gives me if 11 or 22 exists but I need instead AND So I should get Test 1 and Test 2 but not Test 3
SELECT columnA, columnB
FROM table CROSS JOIN UNNEST (columnB) as b
Where B in (11,22)
CodePudding user response：
Check out 