title: com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row
body: <p>I am trying to get the first column in the first row of my result set. I know I can change my SQL query to do that. BUT no. I want the full table and I only want to do what I just mentioned.</p>
  
  <p><strong>NOTE - Winners is an Aliased column in my sql query.</strong> </p>
  
  <p>The error is basically -</p>
  
  <pre><code>com.microsoft.sqlserver.jdbc.SQLServerException: 
  The result set has no current row.
  </code></pre>
  
  <p>More of the error - </p>
  
  <pre><code>at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
  at com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyResultSetHasCurrentRow(SQLServerResultSet.java:483)
  at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(SQLServerResultSet.java:2047)
  at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082)
  at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067)
  at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(SQLServerResultSet.java:2401) 
  </code></pre>
  
  <p>This is what I have tried so far and I need your help to fix it - </p>
  
  <pre><code>ResultSet rs = statement.executeQuery("get a whole table"); //pseudocode
  
  try{            
      rs.next();
      numberOne = rs.getString("Winners");
      rs.first(); 
  } catch (SQLException e) {
      e.printStackTrace();
  }
  </code></pre>