title: how to limit the amount of sql data that i want to display?
body: <p>example of what i have in my database :</p>
  
  <pre>
  sub-category | item
  -----------------------
  Fruit        | Orange
  Fruit        | Apple
  Fruit        | Pineapple
  Fruit        | Cherry
  Vegetable    | Potato
  Vegetable    | Celery
  Vegetable    | Ginger
  Vegetable    | Carrot
  Drinks       | Coffee
  Drinks       | Tea
  Drinks       | Coke
  Drinks       | Pepsi
  </pre>
  
  <p>I tried to use the following code, but it only displays 1 item per category instead of displaying all the items:</p>
  
  <pre><code>SELECT SubCategory, Item
  FROM ItemList 
  GROUP BY SubCategory 
  ORDER BY item DESC 
  </code></pre>
  
  <p>What I get is :</p>
  
  <pre>
  sub-category | item
  -----------------------
  Fruit        | Apple
  Vegetable    | Carrot
  Drinks       | Coke
  </pre>
  
  <p>What I want is the following (example with a display limit of 2):</p>
  
  <pre>
  sub-category | item
  -----------------------
  Fruit        | Apple
  Fruit        | Cherry
  Vegetable    | Carrot
  Vegetable    | Celery
  Drinks       | Coke
  Drinks       | Coffee
  </pre>