I have a BigQuery table like below

I want to return the rows whose col_1, col_2, and col_3 values are not the same.
In the example above, it should return the 2nd and 3rd row (with key ghj-ikl and tgl-pkl). All 3 columns have to have the same values.

How can I do that?
Thanks

>Solution :

Consider below approach (BigQuery Standard SQL)

select * from your_table 
where (
  select count(distinct el) > 1
  from unnest([col_1, col_2, col_3]) el
)    

if applied to sample data in your question – output is