Вопрос интервью Sql server

---

I have attended an interview recently, and the interviewer asked me this question:

UserId  UserName
1          Name1
1          Name2
2          Name3
Here he wants me to retrieve either Name1 or Name2 using where condition?

How can I get the result?

I wrote like

select Username from Users where Username='Name1' or Username='Name2' 

but here both the conditions are satisfied so two records are coming... What will be the query to retrive the data?

Что я уже пробовал:

select Username from Users where Username='Name1' or Username='Name2' 

---