SORTDOWNBY
Use SORTDOWNBY to sort the objects of a series based on a component that the objects contain.
The SORTDOWNBY
function returns the input series, sorted in descending order by the value of the specified component.
- When the character set of the data is ASCII, the objects are sorted in ASCII descending order.
- For all other character sets, the objects are sorted in binary descending order.
The SORTDOWNBY function does not sort the output of the EXTRACT, REJECT, or UNIQUE functions.
- Syntax:
- SORTDOWNBY (series-item-expression, single-item-expression)
- Meaning:
- SORTDOWNBY (group_series_to_sort, group_component_to_sort_by)
- Returns:
- A series object
SORTDOWNBY returns a series of instances of a group, sorted in descending order by the value of an item that the group contains.
Example
In this example, the group Soldier contains the items:
- Name
- Rank
- Serial number
SORTDOWNBY (Soldier:Army, Rank:Soldier:Army)
Related functions
- SEARCHDOWN
- SEARCHUP
- SORTDOWN
- SORTUP
- SORTUPBY