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
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
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.