delete from AAA where (name ,valu) in( select name ,valu from AAA group by (name,valu) having count(*) > 1 ) and id not in (select min(id) from AAA group by (name,valu) having count(*)>1)
【评论】 【打印】 【字体：大 中 小】 本文链接：http://blog.pfan.cn/1mi2/52269.html
delete from AAA where (name ,valu) in( select name ,valu from AAA group by (name,valu) having count(*) > 1 ) and id not in (select min(id) from AAA group by (name,valu) having count(*)>1)
阅读(1570) | 评论(0)
版权声明：编程爱好者网站为此博客服务提供商，如本文牵涉到版权问题，编程爱好者网站不承担相关责任，如有版权问题请直接与本文作者联系解决。谢谢！
评论