On Tue, Aug 21, 2012 at 4:45 PM, Bart Smissaert
<bart.smissaert@...> wrote:

> Posted before, but didn't come through as far as I can see.
>
> Firebird 1.5, classic on Windows.
>
> Have a table with this structure:
>
> CREATE TABLE KEYWORD(
> TERM_KEY CHAR(10) NOT NULL,
> TERM_ID CHAR(5) NOT NULL)
>
> There are non-unique indexes on both fields and there are duplicate records.
> Now I am trying to run a SQL to delete duplicate records:

Personally, I am not fond of doing stuff with system fields and tables.
If I were you, I'd probably use a stored procedure because you are
always in control of the SQL and all of its side-effects and it's also
resilient to engine changes.

Regards,

A