title: Issue with query structure
body: <p>I have a requirement :</p>
  
  <pre><code>user id    full role                           
  a123456    abcd:READ_ONLY     
  a123456    fghi:READ_ONLY                  
  </code></pre>
  
  <p>My target is to get both the rows using distinct keyword:</p>
  
  <p>I am using below query:</p>
  
  <pre><code>select distinct 
           user id,
           SUBSTR(full role, INSTR(full role, ':')+1) end as ROLE
  from table 
  </code></pre>
  
  <p>but i am only able to achieve one row only. Can you please help me with that.I dont want to remove distinct from query because there are lot of other roles available as well in which full role can be same.</p>
  
  <pre><code>a123456     READ_ONLY
  a123456     READ_ONLY
  </code></pre>