|
|
Posted by Ed Murphy on 12/02/06 23:21
rcamarda wrote:
> Your suggestion for the new SQL: Is your point that since I am using a
> where clause, it is redundant to have the additional group by's?
That, and also
GROUP BY STUDENT_ID
HAVING SUM(ACTIVITY_COUNT) > 0
will pick up the same students as
GROUP BY SESSION_ID, STUDENT_ID, STUDENT_STATUS
HAVING SUM(ACTIVITY_COUNT) > 0
(assuming that ACTIVITY_COUNT is never negative).
Navigation:
[Reply to this message]
|