title: SQL Query to find Duplicate email under different ID
body: <p>I have a table email table which records the email_id against ind_ref(Unique).</p>
  
  <p><a href="https://i.stack.imgur.com/RiYCW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RiYCW.png" alt="enter image description here"></a></p>
  
  <p>I want to return only those IND_ref which shares the same email ID. in my example the query should return IND_ref 1212 and 1555 as both shares abc@yahoo.com. How can i achieve this? Any help would be much appriciated. </p>