How to remove duplicate rows using CTE?

Question

I would like to remove duplicate rows from my table. So that I have used ROW_NUMBER() function in order to find the duplicate values. After that I wanted to add WHERE claues to my query and so that I modify my query and used "CTE" but it gives me an error

ORA-00928: missing SELECT keyword

This is the query which runs successfully for my use case :

WITH RowNumCTE as
(
 SELECT ID,parcelid,propertyaddress,saledate,saleprice,legalreference,
         ROW_NUMBER() OVER
         ( PARTITION BY parcelid,propertyaddress,saledate,saleprice,legalreference 
               ORDER BY id ) AS rn
    FROM housedata
)
SELECT *
  FROM RowNumCTE

Answer 1

To delete duplicates:

delete housedata where rowid in
       ( select lead(rowid) over (partition by parcelid, propertyaddress, saledate, saleprice, legalreference order by id)
         from   housedata );

To delete duplicates using a CTE:

delete housedata where id in
       ( with cte as
              ( select id
                     , row_number() over(partition by parcelid, propertyaddress, saledate, saleprice, legalreference order by id) as rn
                from   housedata )
         select id from cte
         where  rn > 1 );

Answer 2

--Remove Duplciates[SKR]

--Option A:

select * 
--delete t
from(
    select rowNumber=row_number() over (partition by SomeKey order by SomeKey), SomeKey from YourTable m 
)t where rowNumber > 1;

--Option B:

with cte as (
    select rowNumber=row_number() over (partition by SomeKey order by SomeKey), SomeKey from YourTable m 
) 
--delete from cte where rowNumber > 1
select * from cte where rowNumber > 1