title: Oracle group by minute
body: <p>I have written a query to get the data received with respect to every hour in a day. </p>
  
  <pre><code>SELECT To_CHAR( A.req_start_time , 'DD/MM/YYYY HH24') as input , count(A.REQUEST_ID)
  FROM ILBULK.SAS_RE_TASK_MESSAGE A,ILBULK.SAS_RE_REQUEST_MESSAGE
  WHERE A.NE_TYPE = 'HLR'
  LIKE '%Synchronous%'
  AND A.REQUEST_ID = ILBULK.SAS_RE_REQUEST_MESSAGE.REQUEST_ID and A.REQ_START_TIME &gt; to_DATE ('12/26/2014 00', 'MM/DD/YYYY HH24') and A.REQ_START_TIME &lt; to_DATE('12/27/2014 00', 'MM/DD/YYYY HH24')
  GROUP BY To_CHAR(A.REQ_START_TIME, 'DD/MM/YYYY HH24');
  </code></pre>
  
  <p>And I am getting following response</p>
  
  <pre><code>26/12/2014 02   13823
  26/12/2014 14   4681
  26/12/2014 12   2939
  26/12/2014 18   457
  26/12/2014 03   34327
  26/12/2014 04   15673
  26/12/2014 19   28885
  26/12/2014 06   70699
  26/12/2014 10   10743
  </code></pre>
  
  <p>Now i want to get data with respect to every minute ordered in ascending order, I have tried to split the hours but nothings working. How do I do that?</p>