在“SQL”后输入“select rowid, name from names;”。 在“SQL”后输入“delete from names a where rowid > (select min(rowid) from names b where b.name=a.name);”来删除重复记录。 完成上述操作后，输入“select rowid,name from names;”，然后输入“commit”，检查是否仍然存在重复记录。   SQL > select rowid,name from names; ROWID              NAME ------------------ ------------------------------ AABJnsAAGAAAdfOAAA Alan AABJnsAAGAAAdfOAAB Alan AABJnsAAGAAAdfOAAC Carrie AABJnsAAGAAAdfOAAD Tom AABJnsAAGAAAdfOAAF Alan rows selected. SQL > delete from names a where rowid > (select min(rowid) from names b where b.name=a.name ); rows deleted. SQL > select rowid,name from names; ROWID              NAME ------------------ ------------------------------ AABJnsAAGAAAdfOAAA Alan AABJnsAAGAAAdfOAAC Carrie AABJnsAAGAAAdfOAAD Tom rows selected. SQL > commit; Commit complete.
选择要删除的RowID。 删除重复记录。 检查重复记录。