Finding duplicate rows in Cassandra

I have a table as follows:

CREATE TABLE xyz (
    id text,
    profile_name text,
    cret_dt timestamp,
    cret_id text,
PRIMARY KEY(id, profile));

It also has some data.

Now, when I run this query:

select id  from xyz ; 

It returns 165 rows

Again, when I run this query:

select distinct id  from xyz ;

It returns 162 rows.

Is there any way to find out the duplicate 3 rows?