delete from table_name where rowid=(select min(rowid) from table_name where condition_clause);

onewayticket (onewayticket)
(#215021@0)
2001-10-2 -05:00

回到话题: DATABASE: In one table, no primary key, there are two exactly same records. How to delete one of them? tks.

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=215021