You can translate the question and the replies:

Not able to use order by clause for multiple columns

hi i have joined two views and i am trying to use order by clause on the view with the provided functionality in denodo 7 . but i am not able to use two or more columns, Is there any way i can use order by on the integrated view for multiple columns
user
19-08-2021 09:11:04 -0400

1 Answer

Hi, I was able to use order by for multiple columns in a join view. I used a query that looked like the following example: select * from <view_name> order by <column_ name1> desc, <column_ name2> asc; I can add as many columns as I want to the order by clause if I keep adding a comma after each column name. For an overview of the order by clause please check out the [ORDER BY Clause](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/order_by_clause/order_by_clause) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
20-08-2021 14:04:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here