title: select 2nd row of every ID in mysql
body: <p>I have a table :</p>
  
  <pre><code>ID | time
  1 | 300
  1 | 100
  1 | 200
  2 | 200
  2 | 500
  </code></pre>
  
  <p>I want to get <code>2nd row</code> for every <code>ID</code><br>
  I know that I can get <code>1st row</code> as</p>
  
  <pre><code>select ID,time from T group by ID;  
  </code></pre>
  
  <p>But I don't know about how to get 2nd row for every ID.<br>
  I know about <code>limit</code> and <code>offset</code> clause in <code>mysql</code>, but can't figure out how to use them here.<br>
  How can I do it ?</p>
  
  <pre><code>EDIT : Actually, time is not ordered. I forgot to specify that. I have made an edit in the table.
  </code></pre>