SQL Guides

OINO.cloud APIs support SQL aggregation of data using parameter oinoqueryaggregate in the request URL. You can give a comma separated list for aggregation methods like function(fieldName). Aggregation can be combined with oinoqueryselect which limits the selected fields and allowing you to control what fields get grouped together.

Aggregation Methods

The following aggregation methods are supported:

  • count: Count of aggregated values.
  • sum: Sum of the aggregated values.
  • avg: Average of the aggregated values.
  • min: Minumum of the aggregated values.
  • max: Maximum of the aggregated values.
Example 




    

        Freight
        ShipCountry