posted 21 years ago
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