Hi all,

I'm trying to query JPA datastore.

Let's assume that we have a Product entity with ProductId as the
primary key and Prodqty and ProdPrice as attributes.

An example might look like this.

ProductId   Prodqty ProdPrice

1                50        1000
2                34        998
3                45        34343
4                34        998
5                43        232
6                50        1000

Now I'd like to retrieve the rows that are duplicated , that is having
the same values for both ProdQty and ProdPrice.

The result for the above example will be

50 1000
34 998

http://code.google.com/appengine/docs/java/datastore/usingjpa.html#Unsupported_Features_of_JPA
says that aggregate functions are not supported.

Can anyone suggest how to specify a query for this purpose?

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Reply via email to