pgsql 删除任意重复行

delete from xxxx a 
where a.ctid = any(
	array (
		select ctid from (
			select row_number() over (partition by dnportid),
					  ctid 
				from xxxx) t
					where row_number > 1
					 	)
					 		);