Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!