title: Select the second highest value in MySQL
body: <p>I actually try to get the second highest value of a table with this request :</p>
  
  <pre><code>SELECT MIN(`mensualite`) AS min, MAX(`mensualite`) AS max FROM `mensualites`
  WHERE((`financement` = "1200") 
  AND (`mensualite` &lt; ( SELECT MAX(`mensualite`) FROM  `mensualites`)))
  </code></pre>
  
  <p>But unfortunately it still fetch the highest value and not the second. Do you know where is my problem?</p>