title: SQL: distinct in where clause
body: <p>I have a query that after execution shows: </p>
  
  <pre><code>Name  | LasName | City
  -------------------------
  John  | Doe     | London
  John  | Doe     | Berlin
  Martin| Smith   | Paris
  </code></pre>
  
  <p>Is there anything I can do in the WHERE clause section in order to get just one John Doe, no matter the city? </p>
  
  <p>The query is humongous that’s why I’m not posting it in here. </p>
  
  <p>If there’s anything you think I can do, please, post a fake query explaining it, I just need to get the concept. </p>
  
  <p>Thanks a lot!    </p>