Take care Patric.... TAKE care and SKIP problems. before give so many options try to have an idea about the work to do in the grammar/parser/tree. Try to send a mail to *Sir. Steve Strong* (he spent a lot of days on the ANTLR parser).
On Sun, Feb 6, 2011 at 4:56 PM, Patrick Earl <[email protected]> wrote: > K, I'm going to throw a wrench in the works and add a couple options. > > http://en.wikipedia.org/wiki/Select_(SQL)#FETCH_FIRST_clause > > So, to recap: > > Option i: SKIPPING x TAKING y SELECT ... FROM ... WHERE ... ORDER BY ... > Option ii: SKIP x TAKE y SELECT ... FROM ... WHERE ... ORDER BY ... > Option iii: SELECT ... FROM ... WHERE ... ORDER BY ... SKIP x TAKE y > Option iv: SELECT ... FROM ... WHERE ... ORDER BY ... SKIPPING x TAKING y > Option v: SELECT FIRST x SKIP y ... FROM ... WHERE ... ORDER BY ... > Option vi: SELECT TOP x SKIP y ... FROM ... WHERE ... ORDER BY ... > > Patrick Earl > -- Fabio Maulo
