MAX(<table>.<column>, <start>, <end>, <unit>)
<table>.<column>
column starting from <start>
days to <end>
days. When used in the target field, the time period should be positive (in the future). When used in a temporal filter field, the time period should be negative (in the past).
This operator can only be applied to numerical
and timestamp
columns.
IS NULL
or IS NOT NULL
operators.days
by default but can be specified as months
or hours
.