This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to implement GROUP BY in CMP???  RSS feed

 
Stephen Lee
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know that EJB-QL does not support "group by", however, is there any other method which allow me to have the same result and the same performance as the 'group by'?
e.g. I have a table, which has the following data:
Project Qty
================
A123 2
A123 4
A123 5
A124 6
A124 1

How can I obtain the total quantity of each project by using CMP??
Stephen Lee
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!