title: How to get COUNT from ResultSet object?
body: <p>I am passing the following query to a ResultSet object:</p>
  
  <pre><code>String query = "SELECT COUNT( DISTINCT KEY ), SOURCE FROM MY_TBL\n" +
              "GROUP BY SOURCE\n" +
              "ORDER BY SOURCE";
  </code></pre>
  
  <p>I want to capture the counts I am getting for each SOURCE and sum them into a total. How can I capture these counts via ResultSet since COUNT isn't a column name in the ResultSet and I don't think I can return it's value via <code>rs.getInt("COUNT")</code>?</p>