Min
Summary
The Min function returns the “minimum” value, as defined for numeric, string, and date and time types.
Syntax
Min(<any data type>) |
Return Type
The return type matches the input data type.
Details
The function returns the following “minimum” values:
|
Data Type
|
Return Value
|
|---|---|
| Numeric | The minimum numeric value. |
| String | The first value in the alphabetically-sorted list. |
| Date/Time | The oldest date and time. |
Examples
select Min(created_date) from xactly.xc_participant;2014-05-27T18:09:16select Min(last_name) from xactly.xc_participant;'Aardvark'select Min(amount) from xactly.xc_payment;-45778.37 |