On Tue, Aug 21, 2012 at 4:45 PM, Bart Smissaert <[email protected]> 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
