ObjectDB ObjectDB

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

edit
delete
#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
edit
delete

Reply

To post on this website please sign in.