Cacher is the code snippet organizer for pro developers

--how to find rows that are duplicated

select *
from eureka.medications 
where rxcui IN 
(
	select rxcui 
	from eureka.medications
	group by rxcui
	having count(*) > 1
)
order by rxcui

--now delete the duplicate rows:
delete from eureka.medications
where id not IN 
(
	select min(id)
	from eureka.medications 
	--where rxcui = 199959
	group by rxcui
)