Subject Re: [firebird-support] delete duplicate row
Author Steve Wiser
try using the rdb$db_key for this problem. just don't rely on it as a
long term key since it changes after a backup/restore cycle I think.


Tiago Mikhael Pastorello Freire wrote:
> Dear all,
> I have this table which stores the values of a looong questionnaire,
> and there
> are some duplicated entries. There are some complications. It was not
> developed by me, and it was rushed online. The genius has not created a
> primary key or any constraint to define the records by their
> uniquenes, nad
> thus we have a few exact duplicate rows which I should delete all but
> one.
> can someone spare me a bit of magic code to delete the duplicated
> entries and
> leave only one record?