Q&A BY TAG 'row number'

You must sign in to ask a question. If you do not have an account, you can register here

Need to extract the second row of a duplicate in a table
answered 20-10-2020 08:03:34 -0400

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 ...

Answers: 1

row number select derived views

row_number not working with the get_view_columns
answered 14-02-2020 21:44:17 -0500

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...

Answers: 1

row number Delegate get_view_columns

In view row_number() is not working expected.
answered 01-10-2019 06:13:59 -0400

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...

Answers: 3

VQL Vql shell row number

What to use instead of ResultSet.TYPE_SCROLL_INSENSITIVE
answered 25-09-2019 12:00:57 -0400

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?

Answers: 3

row number Resu type_scroll_insensitive

Create a field in a View that contains a Sequence Number
answered 18-07-2018 15:50:09 -0400

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

Answers: 1

row number sequence number