- 843 Views
- 2 replies
- 2 kudos
I’m trying to use sql query on azure-databricks with distinct sort and aliasesSELECT DISTINCT album.ArtistId AS my_alias
FROM album ORDER BY album.ArtistIdThe problem is that if I add an alias then I can not use not aliased name in the order by cla...
- 843 Views
- 2 replies
- 2 kudos
Latest Reply
SELECT album.ArtistId ,DISTINCT album.ArtistId AS my_alias FROM album ORDER BY album.ArtistIdCan you try this
1 More Replies
- 705 Views
- 2 replies
- 1 kudos
I am trying to get the commands for xlock, holdlock, rowlock, readpast in databricks sql.Looking to implement this
- 705 Views
- 2 replies
- 1 kudos
Latest Reply
Hi @Krishna Zanwar​,We dont currently support these features, but you can create a feature request if you would like to have these features added to Databricks SQL. Please follow the instructions from here https://docs.databricks.com/resources/ideas....
1 More Replies
- 3144 Views
- 3 replies
- 3 kudos
I’m trying to use sql query on azure-databricks with distinct sort and aliasesSELECT DISTINCT album.ArtistId AS my_alias
FROM album ORDER BY album.ArtistIdThe problem is that if I add an alias then I can not use not aliased name in the order by ...
- 3144 Views
- 3 replies
- 3 kudos
Latest Reply
The code from above is worked in both cases.
2 More Replies