Question

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

有多个用户,每个用户有多个积分,用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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

答：不能

聚合函数不能用做条件