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
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