Q&A BY TAG 'select'

Hi everyone. I need to create an interface with dynamic values on the interface definition. I will give an example to show what I mean: Normally an interface is created this way: CREATE OR REPLACE INTERFACE VIEW i_inventory_50 ( productpartnumber_0:...

VQL Denodo 8.0 select Interface

Just curious if you have plans to evaluate and implement the "insert into select" syntax that is standard on all RDBMS platforms these days? Often the insert into values() syntax is not enough since you need to select from another table. The above sy...

vdp select

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

Hello I want to create a selection view of a derived view that has a column "date" (localdate), and in this selection view I waht to order by date desc, and I only need the first 2 records. How can I do that in denodo? I have this record: 2019-12-01 ...

select derived view