How to select distinct in SQl Server 2008 but for only one field out of many?

Posted by bakerjr on Stack Overflow See other posts from Stack Overflow or by bakerjr
Published on 2010-04-27T11:48:27Z Indexed on 2010/04/27 11:53 UTC
Read the original article Hit count: 139

Filed under:

I have a query:

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) 

How do I select only the distinct content_name?

© Stack Overflow or respective owner

Related posts about sql-server