title: How to get more column values along with distinct column in the Oracle database?
body: <p>How to get more columns along with distinct column values in Oracle ?</p>
  
  <pre><code>select DISTINCT cname 
  from customer 
  where code is not null;
  </code></pre>
  
  <p>I need <code>cname</code>, <code>cvalue</code>, <code>cdate</code> with <code>distinct cname</code></p>