title: Select Query by Pair of fields using an in clause
body: <p>I have a table called players as follows:</p>
  
  <pre><code>First_Id    Second_Id     Name
  1           1             Durant
  2           1             Kobe
  1           2             Lebron
  2           2             Dwight
  1           3             Dirk
  </code></pre>
  
  <p>I wish to write a select statement on this table to retrieve all rows whose first ids and second ids match a bunch of specified first and second ids.</p>
  
  <p>So for example, I wish to select all rows whose first and second ids are as follows: (1,1), (1,2) and (1,3). This would retreive the following 3 rows:</p>
  
  <pre><code>First_Id    Second_Id    Name
  1           1            Durant
  1           2            Lebron
  1           3            Dirk
  </code></pre>
  
  <p>Is it possible to write a select query in a manner such as:</p>
  
  <pre><code>SELECT * 
  FROM PLAYERS
  WHERE (First_Id, Second_Id) IN ((1,1), (1,2) and (1,3))?
  </code></pre>
  
  <p>If there is a way to write the SQL similar to the above I would like to know. Is there a way to specify values for an IN clause that represents multiple rows as illustrated.</p>
  
  <p>I'm using DB2.</p>