Parameter | Type |
---|---|
value | any |
Returns: any
Example
query:
SELECT GREATEST("foo", "bar")
results:
greatest |
---|
foo |
query:
SELECT GREATEST(890, 1275)
results:
greatest |
---|
1,275 |
The function used to take two values and return the greater of them in standard order. Works with numbers, strings, and dates.
Parameter | Type |
---|---|
value | any |
query:
SELECT GREATEST("foo", "bar")
results:
greatest |
---|
foo |
query:
SELECT GREATEST(890, 1275)
results:
greatest |
---|
1,275 |