how to Display a single value from multiple values in sql ?

Question

i have same project name multiple times in my table that is not because of redundancy it is multiple times for some reason

how to take a single value from multiple values

 

for eg

 project name

 a

 b

 a

 c

 b

 a

 

 i want it as 

 project name

 a

 b

 c