title: SQL Query to get name that appear twice
body: <p>I have the below Table</p>
  
  <p>Table1</p>
  
  <pre><code>Emp ID | Emp Name
  001    | ABC
  002    | DEF
  003    | GHI
  004    | ABC
  005    | XYZ
  </code></pre>
  
  <p>I am trying to get EMP ID and Emp Name where Emp Name is same but Emp ID is different. There is primary key in the table</p>
  
  <p>Here the output will be </p>
  
  <pre><code>Emp ID | Emp Name
  001    | ABC
  004    | ABC
  </code></pre>