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_gas_used") 
FROM eth.recent_blocks

-- EXPR$0
-- 685908.1

MAX(expression any primitive) → same as input

• expression: Input expression.

Examples

Window function example

SELECT "transaction_count", 
  MAX("total_gas_used") OVER(PARTITION BY "transaction_count") "max_total_gas_used"
FROM eth.recent_blocks
LIMIT 1

-- block_number, max_gas_used
-- 0.03, 450.5

Usage Notes

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