title: second last row of a table mysql
body: <p>I was playing in a MySQL database and wanted to only view the record that had second to last of table but did not get any row the query is given below 
  What is the problem of my query </p>
  
  <pre><code>SELECT * FROM table WHERE id='(LAST_INSERT_ID()-1)'
  </code></pre>