title: make result set as table
body: <p><strong>HI,
  I want to make the result set as a table to choose from</strong></p>
  
  <pre><code>ResultSet rs=statement.executeQuery("SELECT FROM");
  </code></pre>
  
  <p>To make it clear I used the sql server and typed</p>
  
  <pre><code>select * from (select column from table) as newtable where newtable.column='someting'
  </code></pre>
  
  <p>this works in the sql server but not in the java </p>