Q&A BY TAG 'Subquery'

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

Building derived views that originally have subqueries in them
answered 16-02-2021 10:07:04 -0500

I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...

Answers: 2

Denodo 8.0 Derived views Subquery

FETCH or LIMIT in a Subquery
answered 20-04-2020 15:00:05 -0400

Are you not able to use FETCH and/or LIMIT in a subquery? This query throws an error - Syntax error: Exception parsing query near 'LIMIT' SELECT a.* FROM view1 INNER JOIN (SELECT joinval from view2 ORDER BY joinval DESC FETCH FIRST 3 ROWS ONLY) AS vie...

Answers: 1


Subquery giving an error
answered 14-10-2019 07:13:30 -0400

Hi I have a VQL query as follows: SELECT * FROM bv_getlistdata WHERE sessionhandle = '123456' and token = (SELECT requesttoken FROM bv_request) The view bv_getlistdata has 2 parameters sessionhandle and token and the bv_request view has a single ou...

Answers: 3


Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

Answers: 1

subquery Execution plans Stored Procedure derived view

Subqueries cannot be included in a SELECT clause
answered 08-03-2017 13:45:30 -0500

Hello, Denodo isn't allowing a subquery to be included in the SELECT clause. Is there any alternative for this? Thanks, Hemant

Answers: 1


SELECT DISTINCT Doesn't work in subquery
answered 14-02-2017 06:51:00 -0500

Hello, Whenever I try running a subquery with SELECT DISTINCT I get the following error message: Query Execution failed Reason: SQL ERROR -50006 [HY000]: Error executing view: Functions min, rank are not executable I'm not sure why this is hap...

Answers: 1

subquery Distinct

Search methods and subquery
answered 24-06-2016 16:12:22 -0400

I am using a webservice source in which I have a parameter in the connection definition. I would like to obtain value(s) for this parameter from another view using a subquery. However during excecuting the whole query an error mesage pops up indicating...

Answers: 1

subquery search methods parameter

can subquery be used in join condition?
answered 25-08-2015 04:41:05 -0400

I'm trying to get the row from table1 with the max effective_date less than or equal to table2.effective_date select blah from table1, table2 where table1.effective_date <= (select max(effective_date) from table1b where table1b.key = table1.key and ta...

Answers: 1

subquery alias