title: Find duplicate records based on two columns
body: <p>I have a table named <strong>employee</strong>, there are many records in this table. Here is some sample data :</p>
  <pre><code>fullname  | address  |  city
  -----------------------------
  AA          address1    City1
  AA          address3    City1
  AA          address8    City2
  BB          address5    City2
  BB          address2    City1
  CC          address6    City1
  CC          address7    City2
  DD          address4    City1
  </code></pre>
  <p>I want to have a <code>SELECT</code> query in sql server which will show only the duplicate records based on the columns <code>fullname</code> and <code>city</code>. For the given data and considering the condition, only the first two records is duplicate. So my expected output should be like below :</p>
  <pre><code>fullname  | address  |  city
  -----------------------------
  AA          address1    City1
  AA          address3    City1
  </code></pre>
  <p>To get this output, I have this query :</p>
  <pre><code>select fullname, city from employee group by fullname, city having count(*)&gt;1
  </code></pre>
  <p>As you can see, it selects two columns only and thus it is giving the following output :</p>
  <pre><code>fullname  | city
  ------------------
  AA          City1
  </code></pre>
  <p>If I re-write the query like below :</p>
  <pre><code>select fullname, city, address from employee group by fullname, city, address 
  having count(*)&gt;1
  </code></pre>
  <p>Unfortunately it is showing <strong>no records!</strong> Can anybody please help me to write the correct query to get the expected result?</p>