How can I update a row in Interbase database?

I have two rows with same data in an Interbase table.The table开发者_如何转开发 does not have a primary key. How can I update a single row in that table?

Interbase tables has a system column named RDB$DB_KEY. You can use that in the WHERE clause of your UPDATE query.

u can update those data directly to table (double click the table and search the data, update), not using SQL.