思路话语

。Arlen:思想有多远你就能走多远...

删除重复行,效率较高的一句sql

delete a from server_business a inner join
(select serverid,businessid from server_business group by serverid,businessid having count(*)>1) b
on a.serverid=b.serverid and a.businessid=b.businessid
left join (select min(id) as id from server_business group by serverid,businessid having count(*)>1) c
on a.id=c.id where c.id is null;

posted on 2009-02-17 11:29  Arlen  阅读(122)  评论(0编辑  收藏  举报

导航