title: Finding duplicate rows in Cassandra
body: <p>I have a table as follows:</p>
  
  <pre><code>CREATE TABLE xyz (
      id text,
      profile_name text,
      cret_dt timestamp,
      cret_id text,
  PRIMARY KEY(id, profile));
  </code></pre>
  
  <p>It also has some data.</p>
  
  <p>Now, when I run this query:</p>
  
  <pre><code>select id  from xyz ; 
  </code></pre>
  
  <p>It returns 165 rows</p>
  
  <p>Again, when I run this query:</p>
  
  <pre><code>select distinct id  from xyz ;
  </code></pre>
  
  <p>It returns 162 rows.</p>
  
  <p>Is there any way to find out the duplicate 3 rows? </p>