How to use a GroupAggregator to Return Rows That Have the Minimum Value for Each Given Group?
Last updated on AUGUST 25, 2015
Applies to:Oracle Coherence - Version 3.7.1 to 18.104.22.168.2 [Release AS10g to 12c]
Information in this document applies to any platform.
The example cache has the following fruit objects:
The goal is to return the SQL equivalent of a correlated sub-query, that is return a result set that is grouped by type and contains the entry (and all attributes) that has the minimum (price), as shown in this table:
This is a simplistic example, in the real world each object might have many more attributes that need to be returned, and which aren't part of the grouping or aggregation.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms