Q&A BY TAG 'Top N'

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

"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered 13-01-2021 02:26:45 -0500

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Answers: 1

Top N SAP DENODO SAP BW/4HANA denodo with tableau

Limit inside Denodo common table expression
answered 02-05-2017 09:49:05 -0400

Is it possible to limit VQL query output inside common table expressions? I mean something like that: "DenodoTable" hh order by "holding" desc **--LIMIT 10** ) select * from cte If uncomment "LIMIT 10', above VQL gives "Syntax error: Exception par...

Answers: 1

Top N CTE Limit