aspose file tools*
The moose likes JDBC and the fly likes About Computer Sum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "About Computer Sum" Watch "About Computer Sum" New topic
Author

About Computer Sum

Tom Keaton
Greenhorn

Joined: Feb 24, 2004
Posts: 17
I use sql like this:
SELECT type, price, advance

FROM titles

WHERE type LIKE '%cook'

ORDER BY type

COMPUTE SUM(price), SUM(advance) BY type



Here is the result set:

type price advance

------------ -------------------------- --------------------------

mod_cook 19.99 0.00

mod_cook 2.99 15,000.00



sum

==========================

22.98

sum

==========================

15,000.00



type price advance

------------ -------------------------- --------------------------

trad_cook 20.95 7,000.00

trad_cook 11.95 4,000.00

trad_cook 14.99 8,000.00



sum

==========================

47.89

sum

==========================

19,000.00



(7 row(s) affected)



but I only find two records use CDaoRecordset::GetRecordCount


undefined
 
Don't get me started about those stupid light bulbs.
 
subject: About Computer Sum