title: Monthly Report - SQL
body: <p>I have the table below, how would I select in SQL the last date of each month (from the list) in each categoryID?</p>
  
  <p>I want to end up with something in the line off:</p>
  
  <p>CategoryID | Current | Date</p>
  
  <pre><code>1      |    5    | 2016-09-30
  1      |    3    | 2016-10-30
  1      |    7    | 2016-11-30
  1      |    2    | 2016-12-30
  </code></pre>
  
  <p>etc. as history builds up.</p>
  
  <p>Image :</p>
  
  <p><a href="https://i.stack.imgur.com/8fJ9B.jpg" rel="nofollow"><img src="https://i.stack.imgur.com/8fJ9B.jpg" alt="enter image description here"></a></p>