Fast Object Database for Java - with JPA/JDO support

Examples of queries

#1

Dear ObjectDB,

Is there somewhere an example in Java that uses getResultList for a Group by query.

Like: SELECT ProductID ,SUM(Quantity)
FROM OrderDetails
Group by ProductID; 

Best Regards,

Paul

#2

See this sections in the manual regarding SELECT queries that select multiple expressions:

What you need is not unique for GROUP BY but for common for queries that return multiple expressions in every result.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply