Subject deleting duplicate records
Author Dixon Epperson
The table I am working with cannot have any restraints or key fields
because there are times when a duplicate record may be desired. I
know I could put an index number on each record and get rid of
unwanted duplicates that way but is there a way to do something like
this?

DELETE FROM TABLE WHERE $RDB_RECNUMBER=(SELECT $RDB_RECNUMBER FROM
TABLE WHERE IDNUM=:id AND STCKNUM=:stknum AND QTY=:qt)

Dixon Epperson