Multi column comparision

Database
Enthusiast

Multi column comparision

I have a requirement to do a multicolumn comparision with harcode values. as below -

select col1, col2 from table where (col3,col4)  in ((1,2),(3,4)) ;

--comparing two sets of values through in list.

can you please correct it. it is throwing syntax error.

2 REPLIES
Senior Apprentice

Re: Multi column comparision

This syntax is not supported on Teradata :-(

You need to write the long version:

select col1, col2 from table 
where (col3 = 1 and col4 = 2)
or (col3 = 3 and col4 = 4)
Enthusiast

Re: Multi column comparision

oh..ok.. thank you.