User16752246494
Databricks Employee
Databricks Employee

‎09-27-2021 10:14 AM

Hi ,

can you please try with the following.

%sql SELECT DISTINCT album.ArtistId AS my_alias 
    FROM album ORDER BY 1 desc

 or 

%sql SELECT DISTINCT album.ArtistId AS my_alias 
    FROM album ORDER BY my_alias desc

View solution in original post