title: SQL query to find name of Employess living in same city
body: <p><a href="https://i.stack.imgur.com/UlwtR.png" rel="nofollow noreferrer">Image of the Table</a></p>
  
  <p>I want an output of Employee names who live in same city
  It should not be like
  ..... where city='Pune' or anything static.
  If the occurance of City is more than once then display the name of employees living in that city </p>
  
  <p><strong>Expected Output</strong></p>
  
  <blockquote>
    <p>| eid | ename    | city<br>
    +-----+----------+--------<br>
    |   2 | Abhishek | Pune<br>
    |   1   | Amitab | Pune<br>
    |   4 | Amy      | Mumbai<br>
    |   5 | John     | Mumbai<br>
    |   3 | Rupali   | Mumbai<br>
    |   7 | Sachin   | Satara<br>
    |   6 | Sachin   | Satara  </p>
  </blockquote>