title: SELECT row with Same Value in one Field but different value in another respective field
body: <p>I have a  query </p>
  
  <pre><code>SELECT clientcode, 
         branchcode, 
         maincode, 
         name, 
         actype, 
         cycode 
  FROM   Master 
  WHERE  name IN (SELECT name 
                  FROM   Master 
                  GROUP  BY name 
                  HAVING Count(name) &gt; 1) 
         AND isblocked &lt;&gt; 'C' 
         AND actype &lt; '4E' 
  ORDER  BY branchcode, 
            name, 
            actype, 
            cycode 
  </code></pre>
  
  <p>Now I need to select the row from output of above query where Name is Same but ClientCode is different.</p>
  
  <p>For Eg, two row have same name, suppose 'BISHNU BHANDARI' but they should have different clinetCode like '123' for one and '444' for another. </p>