I do not know. I wonder, though, if you could reformulate your subquery as an OLAP query and add a predicate on RANK? That might have the effect you are looking for.
From: Eric Owhadi [mailto:[email protected]] Sent: Wednesday, December 21, 2016 12:18 PM To: [email protected] Subject: LIMIT and ORDER BY in sub-queries Hello Trafodioneers, I see that we are not supporting LIMIT inside subqueries, and that ORDER BY inside subqueries are ignored. Is there a CQD to change this default behavior? Thanks in advance for the help, Eric
