title: remove duplicate values of only one column value from all the available columns in sql query
body: <p>I have a sql query with three columns .I want to remove any duplicate value exits in beam_current column.How to do so.I work in sql-server2012</p>
  
  <p>I used Distinct but then also I'm getting duplicate values of beam_current.
  My sql Query is-</p>
  
  <pre><code>select DISTINCT (beam_current), logtime, beam_energy 
  from INDUS2_BDS.dbo.DCCT 
  where logtime between '2014-08-09 01:13:03' and '2014-08-09 02:16:53'
        and (beam_current like '%9.96' 
             or beam_current like '%9.97' 
             ... etc ...) 
        and beam_energy between '550' and '552'
  </code></pre>
  
  <p><strong>EDIT-1</strong>
  My output is-</p>
  
  <p><img src="https://i.stack.imgur.com/3P4Nu.png" alt="enter image description here"></p>
  
  <p>In first column 29.98 is repeating thrice.I only want any one of the row corresponding to 29.98.How to do that??</p>