Returns the largest row(s) in the {0}, given the {1}. After the rows are sorted, the {2} parameter must be specified to further filter the result. Note the sorting algorithm cannot guarantee a fixed sorted result. The {2} parameter can take multiple forms:
- If a number is specified, a list of up to {2} items in ascending order is returned.
- If a condition is specified, a list of items that initially meet the condition is returned. Once an item fails the condition, no further items are considered.
Returns the item that appears most frequently in the list, {0}. If the list is empty an exception is thrown. If multiple ...
Returns the items in list {0} that do not appear in list {1}. Duplicate values are supported. An optional equation criteria ...
Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
Returns the largest numeric value in a column, or the larger value between two scalar expressions. Ignores logical values ...
Returns the largest row(s) in the {0}, given the {1}. After the rows are sorted, the {2} parameter must be specified to further ...
Returns the last day of the month in {0}. {0}: A date , datetime , or datetimezone value from which the end of the month ...
Returns the last day of the week in the provided date , datetime , or datetimezone {0}. This function takes an optional Day ...
Returns the last item in the list {0}, or the optional default value, {1}, if the list is empty. If the list is empty and ...
Returns the last item of the list {0}. If the list is empty, an exception is thrown. This function takes an optional parameter, ...