title: Grouping by MONTH in SQL
body: <p>I am trying to put together a table that will take a full date, YYYY-MM-DD, pull out only the month information, and then group the months together as individual rows.  </p>
  
  <p>I've tried using the <code>MONTH(DATE)</code> command, with a <code>Group by</code> and <code>Order By</code> command, and I get the months returned for the 4 years listed on the table.  I gives back 48 rows, listed 1-12, repeating 4 times.  I want to get 1 return of 1-12 in order.</p>
  
  <p>Here is the code I have so far.</p>
  
  <pre><code>select MONTH(DATE) As "Month"
  from DW******.SL****
  Group By DATE
  Order by DATE 
  </code></pre>
  
  <p>Just started using SQL, so I apologize for the simple question.</p>
  
  <p>If someone could please give me a hand.  This is Db for i and I was going to use <code>CONVERT</code> but that does not work with our server.  </p>