title: sql Select multiple columns of a table
body: <p>I am trying to a select from a table in oracle DB.</p>
  
  <p>If I do distinct in select statement on single column it works fine but for multiple columns this doesn't seem to work.</p>
  
  <p>for example.</p>
  
  <pre><code>select DISTINCT col1, col2, col3, col4, col5, col6 from table1
  </code></pre>
  
  <p>returns the same result as.</p>
  
  <pre><code>select * from table1
  </code></pre>
  
  <p>Column 2, Column3 has duplicate values. What I want is values of all the above column values but not the duplicate values of column2 and column3.</p>
  
  <p>Can you please help. Your help will be appreciated.</p>
  
  <p>Thanks</p>