title: SQL Selecting all BUT the last row in a table?
body: <p>How can I select all BUT the last row in a table?</p>
  
  <p>I know I can select the last via <code>SELECT item FROM table ORDER BY id DESC LIMIT 1</code> but I want to select ALL but the last.</p>
  
  <p>How can I do this?</p>
  
  <p>Selecting a certain amount and using <code>ASC</code> won't work because I won't know how many rows there are.</p>
  
  <p>I thought about doing a row count and taking that amount and selecting that -1 and using <code>ORDER BY id ASC</code> but are there any easier ways?</p>
  
  <p>Thanks.</p>