db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Padmini Narasingham" <pnarasing...@shellvacationsllc.com>
Subject how to write an aggregate query
Date Thu, 29 Jul 2004 20:36:41 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message