File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

About Computer Sum

 
Tom Keaton
Greenhorn
Posts: 17
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic