sortByDesc

Sorts this DataFrame rows by the specified columns in ascending or descending (default) order.

Returns a new DataFrame containing the same rows, sorted according to the selected columns.

Select columns to sort by, adjust sorting order and nulls position using SortDsl.

The Sort DSL allows selecting columns to sort rows by values in these columns. It also allows reversing the sort order for individual columns or column sets, and controlling the position of null values.

The order in which columns are selected determines the sort priority.

By default, all selected columns are sorted in the original order (ascending in sortBy and descending in sortByDesc). Use reversed to impose the reverse ordering for a column or column set.

By default, null values are considered the smallest values when sorting. Use nullsLast to treat them as the largest values.

See Columns Selection DSL.

See also

• sortBy that sorts rows in ascending order by default.

• sortWith that sorts rows using a custom comparator.

Examples

// Sort rows by "age" column values descending
df.sortByDesc { age }
// Sort rows by "age" column values descending
// and then by the ("name"/"firstName") column values ascending
df.sortByDesc { age and name.firstName.reversed() }
// Sort rows by "weight" column values descending with nulls first
df.sortByDesc { weight.nullsLast() }

Sorting values can also be computed inline using expr.

// Sort rows by the product of "volume" and "quantity" descending
df.sortByDesc { expr { volume * quantity } }

Parameters

Sorts this DataFrame rows by the specified columns in descending order.

Returns a new DataFrame containing the same rows, sorted according to the selected columns.

Select single or multiple columns using their names as Strings. (String API).

The order in which columns are selected determines the sort priority.

See also

• sortByDesc { } overload that uses SortDsl for selecting columns, allowing specifying sort directions and nulls position.

• sortBy that sorts rows in ascending order.

• sortWith that sorts rows using a custom comparator.

Examples

df.sortByDesc("age")
// Sort rows by "age" column values descending
// and then by the ("name") column values descending
df.sortByDesc("age", "name")

Parameters

Sorts rows within each group of this GroupBy by the specified columns in descending order.

Returns a new GroupBy containing the same keys and groups, with rows sorted within each group according to the selected columns.

Don't confuse this with sortByGroup, sortByCount, and sortByKey, which sort key-group pairs instead.

Select single or multiple columns using their names as Strings. (String API).

The order in which columns are selected determines the sort priority.

See also

• sortByDesc { } overload that uses SortDsl for selecting columns, allowing specifying sort directions and nulls position.

• sortBy that sorts rows in ascending order.

• sortByGroup and sortByGroupDesc that sort key-group pairs by values computed for each group.

• sortByCount and sortByCountAsc that sort key-group pairs by group size.

• sortByKey and sortByKeyDesc that sort key-group pairs by key values.

Check out GroupBy grammar.

For more information: See "GroupBy Transformation" on the documentation website.

Examples

gb.sortByDesc("age")
// Sort group rows by "age" column values descending
// and then by the ("name") column values descending
gb.sortByDesc("age", "name")

Parameters

Throws

Sorts rows within each group of this GroupBy by the specified columns in ascending or descending (default) order.

Returns a new GroupBy containing the same keys and groups, with rows sorted within each group according to the selected columns.

Don't confuse this with sortByGroup, sortByCount, and sortByKey, which sort key-group pairs instead.

Select columns to sort by, adjust sorting order and nulls position using SortDsl.

The Sort DSL allows selecting columns to sort rows by values in these columns. It also allows reversing the sort order for individual columns or column sets, and controlling the position of null values.

The order in which columns are selected determines the sort priority.

By default, all selected columns are sorted in the original order (ascending in sortBy and descending in sortByDesc). Use reversed to impose the reverse ordering for a column or column set.

By default, null values are considered the smallest values when sorting. Use nullsLast to treat them as the largest values.

See Columns Selection DSL.

See also

• sortBy that sorts rows in ascending order by default.

• sortByGroup and sortByGroupDesc that sort key-group pairs by values computed for each group.

• sortByCount and sortByCountAsc that sort key-group pairs by group size.

• sortByKey and sortByKeyDesc that sort key-group pairs by key values.

Check out GroupBy grammar.

For more information: See "GroupBy Transformation" on the documentation website.

Examples

// Sort group rows by "age" column values descending
gb.sortByDesc { age }
// Sort group rows by "age" column values ase
// and then by the ("name"/"firstName") column values ascending
gb.sortByDesc { age and name.firstName.reversed() }
// Sort group rows by "weight" column values descending with nulls first
gb.sortByDesc { weight.nullsLast() }

Sorting values can also be computed inline using expr.

// Sort rows by the product of "volume" and "quantity" descending
gb.sortByDesc { expr { volume * quantity } }

Parameters

Throws