RE: LIMIT and ORDER BY in sub-queries

Ah, Obviously, thanks Dave I don't know what I was thinking :), Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Wednesday, December 21, 2016 2:49 PM To: user@trafodion.incubator.apache.org Subject: RE: LIMIT and ORDER BY in sub-queries I haven't tried the ANSI OLAP s

RE: LIMIT and ORDER BY in sub-queries

d. >> From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Wednesday, December 21, 2016 12:30 PM To: user@trafodion.incubator.apache.org Subject: RE: LIMIT and ORDER BY in sub-queries Hi Dave, I thought about hat, but this cannot work without ORDER BY support. This will only address the

RE: LIMIT and ORDER BY in sub-queries

Hi Dave, I thought about hat, but this cannot work without ORDER BY support. This will only address the LIMIT. Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Wednesday, December 21, 2016 2:26 PM To: user@trafodion.incubator.apache.org Subject: RE: LIMIT and ORDER BY in sub

RE: LIMIT and ORDER BY in sub-queries

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:eric.owh...@esgyn.com] Sent: Wednesday, December 21, 2016 12:18 PM To: user@trafodion.incubator.apache.o