title: Also select second to last mysql value
body: <p>I am trying to select the max mileage and the second biggest mileage from a table.</p>
  
  <p>my query so far is:</p>
  
  <pre><code>SELECT oil.empid, oil.mileage, users.name, oil.date, MAX(oil.mileage)
  FROM oil, users
  WHERE oil.empid = users.empid
  GROUP BY oil.empid
  ORDER BY oil.mileage
  </code></pre>
  
  <p>but this selects the first mileage entered and the max.</p>
  
  <p>how do i change this to get the second biggest mileage?</p>