Hi, You can try the following CTE which removes all the identical rows and only leave single row
WITH CTE AS ( SELECT ctid, ROW_NUMBER() OVER (PARTITION BY proj_nbr, proj_name, start_date, end_date, description, notes ORDER BY proj_nbr) AS rn FROM projects WHERE proj_nbr = '4242.02' ) DELETE FROM projects WHERE ctid IN ( SELECT ctid FROM CTE WHERE rn > 1 );