Categories: Aggregate, Window

MAX

Returns the maximum value among the non-NULL input expressions.

Syntax

MAX(expression any primitive) → same as input

• expression: Input expression.

Examples

Aggregate function example

SELECT MAX("total_amount") 
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
-- 685908.1

MAX(expression any primitive) → same as input

• expression: Input expression.

Examples

Window function example

SELECT "trip_distance_mi", 
  MAX("total_amount") OVER(PARTITION BY "trip_distance_mi") "max_total_amount"
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
LIMIT 1
-- trip_distance_mi, max_total_amount
-- 0.03, 450.5

Usage Notes

For information about the data types that are supported in Dremio, see Data Types.