How to write multiple column "in" sql query syntax?
Example :-
I am looking for the name : Peter in all of these 3 columns (or) any of these 3 columns : colA, colB, colC from the table : TableA
select * from TableA
where (colA, colB, colC) in 'Peter'
Table has the columns in a Pivot format. Alternate would be .. writing a union query for each column in syntax.
Can you try
select * from TableA
where 'Peter' in (colA, colB, colC)
'Peter' = colA OR 'Peter' = colB OR 'Peter' = colC
Depending on the cardinality of the dataset, values in those columns equal to "Peter", the effects could be similar or different for the following two scenarios:
select * from TableA
where colA = 'Peter' OR colB = 'Peter' OR colC = 'Peter'
and
select *
from TableA
where colA = 'Peter'
union
select *
from TableA
where colB = 'Peter'
union
select *
from TableA
where colC = 'Peter'
However, my recommendation would be to use the UNION version since it might give better performance in scenarios where the cardinality of "Peter" in each column is small.
In your case, this is ideal since you are looking for a single name
select * from TableA
where colA='Peter' OR colB='Peter'OR colC='Peter'