有以下两种写法：
1. select a.`name`, driver_url
from `schemas` a,
(
select `name`, count(*) from `schemas` GROUP BY `name` HAVING count(*) >2
) b
where a.`name`=b.`name`
2. select name1, driver_url
from
schemas
where name1 in
(
select name1 from schemas GROUP BY name1 HAVING count( * ) > 2
)
where name1 in
(
select name1 from schemas GROUP BY name1 HAVING count( * ) > 2
)
扫一扫
5444
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
