Sql Server Table data Retrival : I have attended a Interview recently interviewer asked me a Question i.e. 

**UserId	UserName**<br/>
    1	       Name1 <br/>
    1	       Name2<br/>
    2	       Name3

Here he want to retrieve either Name1 or Name2 using where conditon?
how cai i get the result 
i wrote like 
select Username from Users where Username='Name1' or Username='Name2' but here both the consditions are satisfying so two records coming...what will be the query to retrive the data please give your answers..
Thanks in Advance