中科新闻网开水桶常见故障排除:SQL server查询问题:如何查出在表二添加有n条记录的所有会员
来源：百度文库 编辑：中科新闻网 时间：2024/04/29 06:35:19
表1 (会员表)
id uid
1 a1
2 a2
3 xx
表二 (会员添加的记录表,一个会员可以有多条记录)
uid c1
a1 1
a1 2
a2 2
a3 3
a1 3
a1 1
a1 2
a2 2
a3 3
a1 3
a1 1
a1 2
a2 2
a3 3
a1 3
问题: 列出 在表二 中有五条记录的 所有会员
id uid
1 a1
2 a2
3 xx
表二 (会员添加的记录表,一个会员可以有多条记录)
uid c1
a1 1
a1 2
a2 2
a3 3
a1 3
a1 1
a1 2
a2 2
a3 3
a1 3
a1 1
a1 2
a2 2
a3 3
a1 3
问题: 列出 在表二 中有五条记录的 所有会员
SELECT uid FROM 表二 GROUP BY uid HAVING COUNT(*) = 5
select *,(select count(*) from 表二 where uid=表一.uid) as nnn from 表一 where nnn=5
select * from 表一
where uid in
(
select uid
from 表二
where count(uid)=5
group by uid
)