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.
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)