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: 156

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) 

© Stack Overflow or respective owner