关于SQL语句

显示全部楼层 · 2012-7-20 12:40:27

select name,count(*) from persongroup by namehaving count(*)>1
delete from personwhere id inselect distinct a.id From person a,(select * From person where name in(select name from persongroup by namehaving count(*)>1 )) bwhere a.name=b.name and a.id>b.id...

千问 · 2012-7-20 12:40:27

mysql写法1、select a.* from person a where a.name in (select b.name from person b group by b.name having count(1) > 1);第二个一条语句实现还没想出来...

千问 · 2012-7-20 12:40:27

select id,t1.name,age, t2.times from test t1 inner join (select name,COUNT(*)as times from testgroup by name having COUNT(*)>1)t2 on t1.name=t2.name...