Sorting functions

Reference documentation for Expressif functions in the sorting scope.

Name	Overview
ascending	Returns the sort term with ascending direction enabled.
bottom	Returns up to count original values from the last rows in sort table order.
bottom-with-ties	Returns the last count rows and all comparer-equal boundary ties in sort table order.
compare	Compares two values in a selected supported domain and returns their relative ordering.
compare-date	Compares two values after date coercion and returns their relative ordering.
compare-datetime	Compares two values after datetime coercion and returns their relative ordering.
compare-numeric	Compares two values after numeric coercion and returns their relative ordering.
compare-ordinal	Compares two values as text using deterministic ordinal ordering.
compare-time	Compares two values after time coercion and returns their relative ordering.
dense-rank	Groups original sort table row values by their one-based dense rank without gaps.
dense-rank-by	Groups array elements by their one-based dense rank using typed criteria.
descending	Returns the sort term with descending direction enabled.
nulls-first	Returns the sort term with nulls ordered first.
nulls-last	Returns the sort term with nulls ordered last.
rank	Groups original sort table row values by their one-based SQL rank.
rank-by	Groups array elements by their one-based SQL rank using typed criteria.
sort	Stably sorts a normalized sort table and returns its original row values.
sort-by	Stably sorts an array by one or more typed criteria while preserving original elements.
sort-key	Creates a non-empty ordered sort key from one or more sort terms.
sort-table	Normalizes pairs of sort keys and original values into shared headers and data rows.
sort-term	Creates a sort term from a value and a tuple-bound ordering comparer.
top	Returns up to count original values from the first rows in sort table order.
top-with-ties	Returns the first count rows and all comparer-equal boundary ties in sort table order.