title: How do you access the value of an SQL count () query in a Java program
body: <p>I want to get to the value I am finding using the COUNT command of SQL. Normally I enter the column name I want to access into the getInt() getString() method, what do I do in this case when there is no specific column name.</p>
  
  <p>I have used 'AS' in the same manner as is used to alias a table, I am not sure if this is going to work, I would think not.</p>
  
  <pre><code>Statement stmt3 = con.createStatement();
  ResultSet rs3 = stmt3.executeQuery("SELECT COUNT(*) FROM "+lastTempTable+") AS count");
      while(rs3.next()){
      count = rs3.getInt("count");
      }
  </code></pre>