查询谁推荐的人数大于50的怎么查询啊? /*usertuijian 是存放推荐人数?*/SELECT * FROM member WHERE usertuijian > 50 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不是,要是这么简单就会拉。usertuijian是对于的userid的。 select usertuijianfrom member group by usertuijian having count(*)>50 试试这个select * from member a where exists(select 1 from (select max(userid), usertuijianfrom member group by usertuijian having count(*)>50)b where a.userid=b.userid) 一个SQL语句请教各位大侠 合並復制由於外鍵經常引起數據沖突,如何解決這個問題. T-SQL: 关于 Varbinary(Hex,Int) 与 Varchar(HexString) 之间的(数据类型)转换 对表执行所有的select 操作都报错:对路径的访问被拒绝 我这有段代码说ROOT附近有错误。高手帮忙看下 mssql中如何将字段类型设为“布尔”类型? 该提供什么资料 我有个服务器,装上了SQL,为什么连接不了其它的SQL trigger里使用deleted表的问题 多个not like有简化写法吗?谢谢 求一个SQL语句,见图.... 求一个SQL语句,谢谢
不是,要是这么简单就会拉。usertuijian是对于的userid的。
from member
group by usertuijian
having count(*)>50
select * from member a where exists
(
select 1 from (select max(userid), usertuijian
from member group by usertuijian having count(*)>50)b where a.userid=b.userid)