how to write an aggregate query

[Padmini Narasingham]

How do I write the following query using torque?

select userId, sum(convert(int, Value)) as PointValue 
from SummaryPointsValue 
where selected = 1
group by userId
having userId = 2.0

Thanks in advance for your help
-Padmini



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]