title: How can I use MAX and LIMIT together in MySQL
body: <p>I have a table with the following structure:</p>
  
  <h1>ID | Color</h1>
  
  <p>1 | red<br>
  2 | blue<br>
  3 | yellow<br>
  8 | purple<br>
  10| green<br>
  .<br>
  .<br>
  .<br>
  100|yellow  </p>
  
  <p>I would like to be able to grab the MAX ID value for the first 5 rows.</p>
  
  <p>For example, I would like to do something like so:
  Select MAX(ID) From Table LIMIT 5</p>
  
  <p>Hoping this would return the value 10</p>
  
  <p>But, MySQL keeps returning 100...its like MySQL does not even see the LIMIT clause.</p>