Try this...
Select STUFF((Select Distinct ','+ DegreeName From TableName For XMl Path('')),1,1,'') as ColumnName
Check this link:
http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=3934817c-1a03-4ac9-a0ba-55b2bfbaea0f&tid=72&tkey=uses-of-the-stuff-string-function
If you want to Order the output u can do that by using this...
Select STUFF((Select Distinct ','+ DegreeName From TableName Order by ','+ DegreeName Desc
For XMl Path('')),1,1,'') [Comma Seperated List]