title: How to SELECT items from from an array (IN clause details)?
body: <p>I would like to do something in Java (using iBatis, JDBC, etc., really in SQL) like:</p>
  
  <pre><code>SELECT SUM(rowName) FROM myTable WHERE id = [myArrayOfIds]
  </code></pre>
  
  <p>Where myArrayOfIds can be almost any length. Now I know you can do:</p>
  
  <pre><code>SELECT SUM(rowName) FROM myTable WHERE id IN (x, y, z)
  </code></pre>
  
  <p>but what happens for longer lists? For example my list could be as little as a few items to hundreds or more items. How can I do this?</p>