title: MySQL: How to query to get record in a specific position?
body: <p>I have a simple table (product) with fields id, label.</p>
  
  <p>I want to get the n-th unique row from it. If i query like this:</p>
  
  <pre><code>$query = 'SELECT * FROM product ORDER BY id ASC WHERE id ='.$n; 
  </code></pre>
  
  <p>where $n is a number it will return the row that id = number but my table is something like this:</p>
  
  <pre><code>id | label
   1 | sometext
   4 | sometext
  33 | sometext
  40 | sometext
  </code></pre>
  
  <p>..</p>
  
  <p>i mean, if i want to get the 3-th row which is ( 33 | sometext ) the query wont work.
  Is there a simple way to get the 3-th or 4-th row ?</p>
  
  <p>Thanks.</p>