Returns the maximum value(s) in the list, {0}. After the rows are sorted, optional parameters may be specified to further ...

Returns the maximum value(s) in the list, {0}.
    After the rows are sorted, optional parameters may be specified to further filter the result. The optional parameter, {1}, specifies the number of values to return or a filtering condition. The optional parameter, {2}, specifies how to compare values in the list.
 
  • {0}: The list of values.
  • {1}: If a number is specified, a list of up to {1} 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.
  • {2}: [Opional] An optional comparisonCriteria value, may be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.