title: Oracle Distinct on one column
body: <p>I have the table structure in following way:</p>
  
  <pre><code>ITEM  LOC  STATUS  QTY
  001   RS1    A     10
  001   JS1    I     20
  110   RS1    A     4
  </code></pre>
  
  <p>I want to retrieve the results based on distinct ITEM only, regardless of that the values come with that </p>
  
  <p>So result should be </p>
  
  <pre><code>ITEM   LOC   STATUS   QTY
  001    JS1     A      10
  110    RS1     A       4
  </code></pre>
  
  <p>How to do that ?</p>