title: Get last record of each month in MySQL....?
body: <p>I have a problem in writing a query for MySQL.
  I have following fields in the DB</p>
  
  <pre><code>id     created_on            status
  1      2011-02-15 12:47:09    1 
  2      2011-02-24 12:47:09    1
  3      2011-02-29 12:47:09    1
  4      2011-03-11 12:47:09    1
  5      2011-03-15 12:47:09    1
  6      2011-03-22 12:47:09    1
  7      2011-04-10 12:47:09    1
  8      2011-04-11 12:47:09    1
  </code></pre>
  
  <p>I need to <code>select the last record of each month</code>.
  That is for the <code>month FEB record # 3</code> <code>month MARCH record # 6</code>
          and for <code>month APRIL record # 8</code></p>
  
  <p>Please help me.....</p>
  
  <p>Thanks in advance.....</p>