SQL In Clause Multiple Columns

sql multiple-columns in-clause in-operator
user1857647 picture user1857647 · Nov 27, 2012 · Viewed 11.4k times · Source 
SELECT *
FROM Tabl tabb
WHERE (tabb.col1, tabb.col2) IN ( (1,2), (3,4))

The above works in Oracle but I am trying to run in a proprietary SQL engine which doesn't support the above query formation with multiple columns in IN.

I am trying to find combinations of 1,2 and 3,4 in the DB.

Please help me with any alternatives for achieving the above.

I am looking for ways to pass a list of values for col1 and col2 from Java at one shot, so '=' might not be an option as it might require two SQL statements for achieving the above.

Answer

hall.stephenk picture hall.stephenk · Nov 27, 2012

How about this?

SELECT
    *
FROM
    Tabl tabb
WHERE
    (tabb.col1 = 1 AND tabb.col2 = 2) OR
    (tabb.col1 = 3 AND tabb.col2 = 4)

Related questions

Using group by on multiple columns

I understand the point of GROUP BY x. But how does GROUP BY x, y work, and what does it mean?

Read More
Select NOT IN multiple columns

I need to implement the following query: SELECT * FROM friend WHERE ( friend.id1, friend.id2 ) NOT IN (SELECT id1, id2 FROM likes) But NOT IN can't be implemented on multiple columns. How do I write this query?

Read More
Combine multiple rows into multiple columns dynamically in SQL Server

I have a large database table on which I need to perform the action below dynamically using Microsoft SQL Server. From a result like this: badge | name | Job | KDA | Match - - - - - - - - - - …

Read More