title: Is there a way to use ORDER BY and still use deleterow()?
body: <p>The code I'm using deletes the last row in the database. From what I have read, once I've used <code>ORDER BY</code> it will set the result back to read only which makes <code>deleterow()</code> or anything else involving updating the database not possible.</p>
  
  <p>Is there a work around so I could make the table <code>ORDER BY Score DESC</code> and still delete the row I need to delete?</p>
  
  <pre><code>        String host = "jdbc:derby://localhost:1527/Scores";
          String uName = "root";
          String uPass= "root";
  
           Connection con = DriverManager.getConnection( host, uName, uPass );
           Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                  ResultSet.CONCUR_UPDATABLE);
  
           String SQLd = "select * from ROOT.HISCORES ORDER BY Score DESC";
  
           ResultSet dl = stmt.executeQuery( SQLd );
  
           dl.last();
           dl.deleteRow();
  
      }
  </code></pre>