New answers tagged

0

I guess you mean this query: SELECT * FROM mytable WHERE column1 IN ('a', 'b') AND column2 = 'xyz'


1

Formally you may try to use something like WITH cte1 AS (SELECT name, email1 email FROM table UNION ALL SELECT name, email2 FROM table UNION ALL SELECT name, email3 FROM table UNION ALL SELECT name, email4 FROM table), cte2 AS (SELECT email FROM cte1 ...


Top 50 recent answers are included