create temporary table tmp as SELECT test.name name,test.age age from test GROUP BY test.name,test.age HAVING count(*)>1; delete from test where EXISTS (select * from tmp where test.age=tmp.age and test.name=tmp.name); 根据楼主的语句改的。可行。
点赞 评论

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务