Does databricks SQL support row number operations?

[Hubert-Dudek · Accepted solution]

Yes, it is supporting window functions https://docs.databricks.com/sql/language-manual/sql-ref-window-functions.html; one of them is row_number()

[Kaniz]

Hi @Frank Zhang-Zheng​ , We haven’t heard from you on the last response from @Hubert Dudek​, and I was checking back to see if his suggestions helped you. Or else, If you have any solution, please share it with the community as it can be helpful to others.