title: How to select non-distinct rows with a distinct on multiple columns
body: <p>I have found many answers on selecting non-distinct rows where they group by a singular column, for example, e-mail. However, there seems to have been issue in our system where we are getting some duplicate data whereby everything is the same except the identity column.</p>
  
  <pre><code>SELECT DISTINCT 
        COLUMN1,
        COLUMN2,
        COLUMN3,
        ...
        COLUMN14
    FROM TABLE1
  </code></pre>
  
  <p>How can I get the non-distinct rows from the query above? Ideally it would include the identity column as currently that is obviously missing from the distinct query.</p>