I would like to know is there any possible way to restriction a user (newly created or existing one) when creation views. Example: a user " trainer" who have create, read, write privileges. but need to restriction the user from creating more than 5 view.
Answers:
1
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
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