• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to implement GROUP BY in CMP???

 
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!