Subject | deleting duplicate records |
---|---|
Author | Dixon Epperson |
Post date | 2003-08-29T19:14:14Z |
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
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