title: Group by -SQL ORACLE
body: <p>My column contains these values.</p>
  
  <pre><code>ABCD INC.
  ABCD INC REGISTERED 
  ABCD ORD SHS
  ABCD ORD REGISTERED 
  </code></pre>
  
  <p>How can I use correct group by using substring function so my distinct values looks like this?</p>
  
  <pre><code>ABCD 
  </code></pre>