title: How to select the records that are sharing the same Id but with different Name?
body: <p>I have a table like below:</p>
  
  <pre><code>Col_Name   Col_Id  Col_Flag
    A          1        1
    A          1        2
    B          1        1
    C          2        1
    C          2        2
  </code></pre>
  
  <p>For those records, I'd like to get the result for which <code>Col_Id</code> are sharing by differnet <code>Col_Name</code>, for the example above, the desired result is to return <code>Col_Id</code> as <code>1</code>, because it is sharing by <code>A</code> and <code>B</code>, and I do not want <code>Col_Id = 2</code> get returned because only <code>C</code> is using this value. </p>
  
  <p>And, the total number of the same <code>Col_Name</code> that are using the same <code>Col_Id</code> is not limited to <code>2</code>, meaning the <code>Col_Flag</code> could be larger than 2.</p>
  
  <p>Any suggestions will be much appreciated. Thanks.</p>