sql sum函数计算过的数据.能作为条件吗

来源：百度知道 编辑：UC知道 时间：2024/05/30 03:01:53
有多个用户,每个用户有多个积分,用SQL语句显示每个用户的积分总和
Select d.userid,sum(d.interal)
From details d
Group By d.userid,d.interal
语句上可以加条件只显示某一积分总和是多少的用户吗
可以这样写吗
Select d.userid,sum(d.interal)
From details d
where sum(d.interal) = '2000'
Group By d.userid,d.interal

Select d.userid,sum(d.interal)
From details d
Group By d.userid,d.interal
having sum(d.interal) =10

用having关键字可以作为条件，因为是聚合函数吧

答：不能

聚合函数不能用做条件

Select * From (
Select d.userid,sum(d.interal) AS SUMM
From details d
Group By d.userid,d.interal
) TBL
Where SUMM>xxx

Select d.userid,sum(d.interal) as suminteral
From details d
Group By d.userid,d.interal
having suminteral =10

有点困惑 你在d.interal 这个字段下记录的是什么内容