sql 语句编写

[eimhee]

有一条SQL语句如下 : 是计算用户的整积分
我 想求的是用户的整积分 , 不论时间段是多少,
但只显示出在这个时间段有积分的用户
该怎么写呢
SELECT userID, sum(Points) AS points
FROM Reward
where
creationDate >= 1232088570051
and creationDate <= 1332088570051
GROUP BY userID
ORDER BY points DESC

[watson110]

SELECT userID, sum(Points) AS points 
                  FROM Reward 
                where 
                    creationDate >= 1232088570051 
                  and creationDate <= 1332088570051 and Points is not null
                GROUP BY userID 
                ORDER BY points DESC

[fubinghao686]

我感觉这样写就行得，但是通不过得话，我就只能坐个个屁股得沙发了，呵呵，等待高手

[zabaglione]

问题描述的太简单了。
看不到lz到底想要什么效果

[eimhee]

我的意思是先求出总积分
表1 SELECT userID, sum(Points) AS points
FROM Reward
GROUP BY userID
ORDER BY points DESC


表2 SELECT userID
FROM Reward
creationDate >= 1232088570051
and creationDate <= 1332088570051

表1中的USERID只能在表2中
SQL语句我是写出来了 但执行起来特别慢

[yangzeDB]

行

[bsh_ly]

SELECT A.USER_ID, SUM(A.POINTS)AS POINTS
FROM REWARD A,  REWARD B
WHERE A.USER_ID = B.USER_ID
AND 
(
    B.reationDate >= 1232088570051
AND B.creationDate <= 1332088570051
)
GROUP BY A.USER_ID