Sql Query for multiple items returns in comma seperated model

See more:

SQL

Hi all

Select * from table_details returns

Code    Salesman    date       status

1       s1          1/1/2014    Y
2       s2          2/1/2014    Y
2       s1          2/1/2014    Y
3       s2          3/1/2014    Y

i want query to return rows like

Code    Salesman    date       status

1       s1          1/1/2014    Y
2       s2,s1       2/1/2014    Y
3       s2          3/1/2014    Y

How to do this

Thanks in Advance

Amritha