title: How to select distinct in SQl Server 2008 but for only one field out of many?
body: <p>I have a query:</p>
  
  <pre><code>SELECT Content.content_name, Language2.Name, Language2.language_id, 
  Content.id, Content.content_description, 
  FROM Language AS Language2 
  LEFT JOIN contents AS Content ON (Language2.language_id = Content.language_id) 
  </code></pre>
  
  <p>How do I select only the distinct content_name?</p>