title: Comparing Rows with a group by in SQL Server
body: <p>I have a following result set / table.</p>
  <pre><code>Id       CustName     ItemId         OrderDate  
  -------- ---------- --------------   ------------
  1        AB         1                2020-01-02 
  2        AB         2                2020-01-02
  3        BB         2                2020-01-02  
  4        BB         2                2020-01-02  
  </code></pre>
  <p>Now I want to find out that which customer has ordered the same item more than 1 on same day so after the query the result should looked as below.</p>
  <pre><code>Id       CustName     ItemId         OrderDate  
  -------- ---------- --------------   ------------
  3        BB         2                2020-01-02  
  4        BB         2                2020-01-02  
  </code></pre>
  <p>I have tried self join but not working, Thanks in Advance!</p>