Help Delete Duplicate Record

Off-Topic
1

This work to find duplicate record but how I can delete one of each duplicate

SELECT ta.cntid,ta.itemnum,ta.description,ta.qtynew
FROM reciveddt ta
WHERE (select COUNT(*)
FROM reciveddt ta2
WHERE cntid=1 and ta.itemnum = ta2.itemnum)>1 order by itemnum Asc

2 
DELETE FROM reciveddt ta1
WHERE _rowid=(
SELECT min(_rowid_) as rowid
 FROM reciveddt ta2
WHERE cntid=1 and ta1.itemnum = ta2.itemnum
GROUP by ta2.itemnum
HAVING count(*)>1

this probably isn’t 100% correct as it was off the top of my head, but I think it will point you in the right direction

3

I usually do something like this:

DELETE FROM tableName WHERE Conditions… AND id NOT IN(SELECT MIN(id) FROM tableName WHERE Conditions…)
or

DELETE FROM tableName WHERE Conditions… AND id NOT IN(SELECT MAX(id) FROM tableName WHERE Conditions…)

4

thanks