You can translate the question and the replies:

Perform a join and only keep the first row

Perform a join and only keep the first row when the join condition it met
28-09-2020 19:09:39 -0400

1 Answer

Hi, I would add the clause LIMIT in the query which performs join to obtain only one row of the result set. For instance, If I have a join view called dv_join_view then I would execute the following query: `Select * from dv_join_view LIMIT 1` Similarly, I would use OFFSET and FETCH clauses to limit the number of rows obtained when executing a query. Additionally, I could also limit the no. of rows graphically by following the steps given below: * Open the derived view * Click the Execution panel. * Edit the Limit Rows/Display Rows value to the desired value. For more information, you can have a look at the sections [OFFSET, FETCH and LIMIT]( of the Virtual DataPort VQL Guide and [Querying Views]( of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
29-09-2020 08:09:21 -0400
You must sign in to add an answer. If you do not have an account, you can register here