title: Group by hour using Oracle SQL
body: <p>I have a varchar5 column with times from </p>
  
  <pre><code>00:00
  00:01
  00:02
  00:03
  
  ... all the way to 
  23:59
  </code></pre>
  
  <p>How would I count how many minutes are in an hour? To get the result</p>
  
  <pre><code>00 60
  01 60
  02 60
  and so on...
  </code></pre>
  
  <p>SQL:</p>
  
  <pre><code>select 24_HOUR_CLOCK
  From time table
  Group by ...
  Order by 24_HOUR_CLOCK ASC
  </code></pre>
  
  <p><strong>Means to count records</strong></p>