title: Select specific row from mysql table
body: <p>Ideally I need a query that is equivalent to </p>
  
  <pre><code>select * from customer where row_number() = 3
  </code></pre>
  
  <p>but that's illegal.</p>
  
  <p><strong>I can't use an auto incremented field.</strong> </p>
  
  <p>row_number() is the row that needs to be selected.</p>
  
  <p>How do I go about this?</p>
  
  <p>EDIT: Well, I use iSql*plus to practice, and using limit and auto_increment is illegal for some reason. I ended up creating a sequence and a trigger and just upped the id by 1 every time there was an entry.</p>