Latest Activity


Need to extract the second row of a duplicate in a table

Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...

row number select derived views


row_number not working with the get_view_columns

Hello Denodo gurus! Why does row_number not work with the get_view_columns? select database_name, view_name, column_name as denodo_column_name, ROW_NUMBER() OVER ( PARTITION BY view_name ORDER BY database_name ) row_number_with_partition from get_vi...

row number Delegate get_view_columns


In view row_number() is not working expected.

In view row_number() is not working expected. but same query from VQL Shell giving me expected results. What is the issue ? I pass same where clause. From VQL shell which is need row_number 1 1 2 3 4 From View row_number 49 50 51 52 115 What caus...

VQL Vql shell row number


What to use instead of ResultSet.TYPE_SCROLL_INSENSITIVE

I am aware that ResultSet.TYPE_SCROLL_INSENSITIVE is not supported by denodo currently. Do you have a suggestion as to what I can use instead to retrieve the row count of the result set?

row number Resu type_scroll_insensitive


Create a field in a View that contains a Sequence Number

In a (Derived) View, can I create a field that contains a Sequence Number (such as the Row number in the View).

row number sequence number