Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2024 06:50 PM
%sql
SELECT array_sort(array_agg(col)
,(left, right) -> CASE WHEN left < right THEN -1
WHEN left > right THEN 1 ELSE 0 END) arr_col FROM VALUES (3), (2), (1) AS tab(col);
https://docs.databricks.com/en/sql/language-manual/functions/array_sort.html
