how to limit repeated value of a colunm in inserting values

Question

I tried this 

 

 

update Student set Sup_Name =(select top 1 Supervisors.Sup_Name from Supervisors order by newid())where student.St_ID = '98754'

 

 

and I used update beuase I need to insert into one column