title: getting the highest number out of a SELECT query?
body: <p>Imagine i had a set of <strong>30 records</strong>
  for instance </p>
  
  <blockquote>
    <p><code>users : {user_id, name, category}</code></p>
  </blockquote>
  
  <p>and i did this Query:</p>
  
  <pre><code>     SELECT name
       FROM users
       WHERE category = "Student"
       AND id &lt; 30
       ORDER BY user_id
       LIMIT 5
  </code></pre>
  
  <p>This would give me the users that have id from 1 to 5
  but how about if i wanted to get the highest id values that are less than 30
  in this case the desired results would be id's from 24 -29.</p>
  
  <p>ps. my real problem is a bit more complex than this, i just wanted get the basic theory.
  also note that i would of used another AND clause to say > 23, but this wouldnt work with my schema.</p>