ThomazRossito
Contributor

Hi, 

I believe that for your scenario the "sort_array", function can help

https://docs.databricks.com/en/sql/language-manual/functions/sort_array.html

ThomazRossito_0-1712504147539.png

 

Att.
Thomaz Antonio Rossito Neto
Master Data Specialist - Data Architect | Data Engineer @ CI&T