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

Reply