You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

PSOFT DB2 Aggregate Query question

1 reply [Last post]
funkygirl's picture
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 03/20/2009
Posts: 1

Need to only show hours greater than 120 on a SUM FIELD. Cannot figure out exactly how to write my expression. This is not working, SUM(A.TL_QUANTITY) GREATER THAN 120

Ashar's picture
User offline. Last seen 5 years 6 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: PSOFT DB2 Aggregate Query question

did u try HAVING clause?